how to convert blank fields to zero

[Sudha]

Hi,
I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values was difficult for the user . now if the user doesn't enter any value in these columns I need to get zero for these fields in my table. how do I do it?

 

[HiTechCoach]

Make a backup.

Run an update query.

Be sure to make a backup first!

I would also update the form's Before Update event to set the value to Zero

 

[MSAccessRookie]

Hi,
I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values was difficult for the user . now if the user doesn't enter any value in these columns I need to get zero for these fields in my table. how do I do it?

You might be able to set the default value of each of the fields to 0, and then modify the form so that the fields contain a source that displays the Null value? Something like this might work:

IIF(YourColumn=0, "", YourColumn)