setting default value to $0.00 in a currency field

G

Guest

I have set the default value in both the table and the form but neither
works. I need to have $0.00 show by default
 
A

Allen Browne

1. Open the table in design view.

2. Select the currency field.

3. In the lower pane, set the Format to:
Currency
and the Default Value to:
0

Check that this works as expected when you open the table. Then, if
necessary, clear the Default value and Format properties of the text box on
your form (or set them the same way).
 

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

How do I set a default value of $0.00? 2
I am trying to use the IF and SUMIF function on Excel 8
Zeros 2
Currency field default 1
Using the result of a Pull Down as a Switch 5
Currency Format not working 2
Currency Format in Access 2007 6
Sum 4 Fields with conditions 4

Top