How do I print leading zeros in an Access report?

  • Thread starter Thread starter Atholjax
  • Start date Start date
A

Atholjax

I am trying to generate membership cards with membership numbers that have
leading zeros which mean something but they always get truncated.
Anyone solved this problem?

Atholjax.
 
Use the Format function e.g.

Format(123, "000000")

returns:

000123

Or, you can do the same thing using the Format property of a text box i.e.
set it to 000000
 

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

Counting multiple memberships 1
Suppress Leading Zero 7
How can I print 4 pages (postcard size) of a report on one page? 1
How do you print leading zeroes in a zip code 2
I need to print 30 pre-numbered blank line at end of report 2
Keeping Leading Zeros; How Please ? 2
how to print extra blank records 5
Concatenate Date and Number field for Append Query 0

Back
Top