Default Values & Rounding

[Virginia]

I have set values on text fields, where a user will have to enter numbers which should have 6 decimal places. However, when the user enters the number 15.369887, Access automatically rounds it to 16.000000. The user must see the entire number, including the values after the decimal point. Is there a quick way to format this cell to show all the values? In addition, is there a way where the form will show blank fields until the user enters a value? I have $0.00 and 0 showing in the formatted cells. Users would like to see values only after an amount is entered. Any help will be greatly appreciated!

 

[Richie]

Change the field to currency and remove any default value from table/form design.

 

[Virginia]

It works beautifully. Thanks for your help, Richie. I'm now in Access and still learning the basics. Thanks again!

 

[Virginia]

I meant I'm "new" in Access.