View Full Version : How to format a control in an ACCESS form to show zeros


Ligaya
05-28-2007, 06:04 AM
Hello,

I have a text box in an ACCESS form that is blank. How should I format it so that zeros are visible until a digit is entered into that field? This column is for ovetime figures (e.g. 1.35 hours) that will be entered later.

I would greatly appreciate any suggestions and help.

Regards,
Ligaya

boblarson
05-28-2007, 06:07 AM
Set the default to be 0 and if you want 0.00 to be shown, in the format property put Fixed and set the decimal places to 2.

Ligaya
05-28-2007, 06:10 AM
Hello Bob,

Thank you for your help. I shall do exactly that.

Regards,
Ligaya