Access 2007

D

donbl8

I'm having a problem in not being able to display leading zeros in a numeric
field. What am I overlooking?
 
J

John Spencer

That numbers do not have leading or trailing zeroes.

YOu can apply a format to a number. Doing so will using the format
function changes the number to a string. Using the format property of a
control changes the way things are displayed, but the value is still a
number

FORMAT(SomeNumberField,"000000000.00")
will change the number value 1.1 to a string that looks like
000000001.10


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Top