Question...

[Chad]

I have a field where I need to always have 9 digits… however, the value
varies…sometimes 100.00, sometime 50.00… but I need the field to prefilled
“0†in the empty spaces… i.e. “00000100.00†or “0000050.00â€. Do you know how
to make access do that?

 

[Douglas J. Steele]

Create a query and use the Format function (not the Format property) to
return the number as a string.

Use the query wherever you would otherwise have used the table.

 

[Chad]

Great Thanks!

Create a query and use the Format function (not the Format property) to
return the number as a string.

Use the query wherever you would otherwise have used the table.

 

[Chad]

Thank you very much!

x = 50
y = format(x, "0000000.00")
? y
0000050.00

HTH - Bob

 

[Chad]

Can you break this down a bit more for me... I need the "Idiot’s Guide"
version on how to achieve this. Thanks for your help! I appreciate it!

 

[Chad]

Sorry... but I'm learning! Where do I apply the formula you gave me?

Thanks for your help!

 

[Douglas J. Steele]

Create a query as usual and make sure you've added the field in question.

Replace the name of the field on the "Field" row with Format([NameOfField],
"00000000.00")