Access 2007

  • Thread starter Thread starter donbl8
  • Start date Start date
D

donbl8

I'm having a problem in not being able to display leading zeros in a numeric
field. What am I overlooking?
 
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
'====================================================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 - Joining number and text data 3
Droping Leading Zeros In Table 4
Import from Excel to Access 1
Zero fill numeric field 1
Restore leading zero 3
Export table to text file with numeric field to have leading zeroe 1
Export of text field trims leading zeros 1
Report Export To Excel 2

Back
Top