How do I print leading zeros in an Access report?

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

 

[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