How do I print leading zeros in an Access report?

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.
 
B

bcap

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
 
Top