Leading Zeros in Access 2010

[aa_weber]

so.. I have read that the number field doesn't show the leading zeros in 2007... does 2010 have a way to do that, or does it still have to be a text field in order to see them..?

[pbaldy]

You either need a text field or use the Format() function to display the numeric field:

Format(FieldName, "00000")

with the appropriate number of zeros.

[aa_weber]

You either need a text field or use the Format() function to display the numeric field:

Format(FieldName, "00000")

with the appropriate number of zeros.

.... okay, so I tried what I thought you meant, and it didn't work... (probably my error and lack of understanding, though... {silly newbie}..) but I did get it figured out.

In the field property "Format", I entered: 0-0000-0000-0

for my ISBN - 10 numbers
and

000-0-0000-0000-0

for my ISBN - 13 numbers

both now show properly and I can still enter the numbers without having to add the dashes...



.... you were a monumental help to this process, and I am certain I could not have figured it out without you!

Thanks!

[pbaldy]

Glad you have it working, and welcome to the site!