Number formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I format an auto number to display in 4 digits. I want it to start at 0001 and go up from there.
 
In Queries, Forms and Reports, use:

Format([AutoNumField], "0000")



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Barb said:
How do I format an auto number to display in 4 digits. I want it to start
at 0001 and go up from there.
 

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

Similar Threads

Access auto numbers 3
Custom Auto Number 3
MS Access problem 0
Access Macro Repeat Expression using value of a field in table 0
Number Roll Over 1
Auto Log Number 4
Field Format 3
Excel Conditional Formatting 1

Back
Top