Customizing AutoNumber Field

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

How can we make an "AutoNumber" field generate auto-
numbers in a specified

format like for example:
sample-dt-000001
sample-dt-000002
sample-dt-000003
etc., instead of just 1,2,3

Pls help.
Thanks
Mario
 
Mario

Access Autonumber doesn't do that. And if you want not to have headaches
later, you won't do it either. What you described looks a lot like what
belongs in 2 or 3 separate fields. If you want to DISPLAY a collection of
fields as you outlined, you can use a query to do so for your forms ... you
ARE using forms, not entering directly in the tables, right?!
 
Back
Top