Question...

C

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?
 
D

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.
 
C

Chad

Great Thanks!

Douglas J. Steele said:
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.
Click to expand...
 
C

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!
 
C

Chad

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

Thanks for your help!
 
D

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")
 
Top