setting default value to $0.00 in a currency field

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Sum 4 Fields with conditions 4
Zeros 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency field default 1
Currency Format not working 2
Using the result of a Pull Down as a Switch 5

Back
Top