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