How to format a control in an ACCESS form to show zeros

[Ligaya]

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]

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]

Hello Bob,

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

Regards,
Ligaya