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).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"rburek" <(E-Mail Removed)> wrote in message
news:A583A355-0B82-4051-9EAC-(E-Mail Removed)...
>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