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

"Kissi" <kissi5559@aol.comwrote in message
news:E_wwk.8511$Ra1.733@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.

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