By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Help with AutoNumber Data Type

P: n/a
I would like the Auto Number field to have 7 digits and the first character
"E" eg ; E0000001, E0000002...,E00000120. Can someone help please?

Sep 6 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Kissi" <ki*******@aol.comwrote in message
news:E_****************@fe18.usenetserver.com...
>I would like the Auto Number field to have 7 digits and the first character
"E" eg ; E0000001, E0000002...,E00000120. Can someone help please?
An Auto Number is a number, so you can't have an E in it.

Could you just print an E on your forms/reports, as a table, or as a
concatenated field:
="E" & [YourAutoNumberFieldNameHere]

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Sep 6 '08 #2

P: n/a
Kissi wrote:
I would like the Auto Number field to have 7 digits and the first
character "E" eg ; E0000001, E0000002...,E00000120. Can someone help
please?
You can *display* all such values with a format property of...

"\E0000000"

It is not possible with an AutoNumber to (nor necessary) that the values be
saved with that format.

Of course AutoNumbers will naturally develop gaps in most cases so if you
don't want that then you have to use a numering system other than
AutoNumber. Even in those cases I would still not save the data as you
indicate, but only display it that way on forms and reports.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Sep 6 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.