Hi Ryan,
If you set the Format property to
\f&&
You will get results of
f1
f2
f3
..and so on
If you are needing to Pad zeros then you may want to take a look at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;210573
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| From: ryanb <
[email protected]>
| Subject: Custom AutoNumber
| Date: Mon, 14 Jun 2004 21:16:39 -0500
| Message-ID: <
[email protected]>
| Organization: MSAccessForum.com
| User-Agent: MSAccessForum.com
| X-Newsreader: MSAccessForum.com
| X-Originating-IP: 202.139.47.2
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: 69-56-172-122.theplanet.com 69.56.172.122
| Lines: 1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:80665
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
|
Hi all,
|
| I'm new here, so here goes my first question.
|
| I'm making a table for tracking a type of form that I use.
|
| The forms are numbered for tracking and I want to apply that number to
the table, the field is set to 'Autonumber' & is also the primary key,
what I want to to is for the autonumber to be formated like so 'F0001'
being the first and then counting on from there.
|
| Can anyone let me know how to do this?
|
| Cheers,
|
| Ryan B
