Customizing AutoNumber Field

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
 
J

Jeff Boyce

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?!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top