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
'====================================================
