Missing Zero's in Lables

  • Thread starter Thread starter Gayle
  • Start date Start date
G

Gayle

I've created lables that include employee numbers. Some
of the numbers begin with zero, but in the lables report,
the leading zeroes are missing. How can I keep them there?
 
Numbers used for identification only, not calculated, are often best kept in
text form. Otherwise, the number of leading zeros you see is a factor of the
formatting of the output... lead zeros that you see in decimal form are not
related to how the number is stored, which is in binary form (except for
Currency).

If you want, always, ten numeric digits, no more, no less, use a format of:
Format(yournumvariable, "0000000000").

Larry Linson
Microsoft Access MVP
 
Back
Top