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
 
Back
Top