how to convert blank fields to zero

Sudha · Mar 6, 2009

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 · Mar 6, 2009

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 · Mar 6, 2009

Sudha said:
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:

Code:

IIF(YourColumn=0, "", YourColumn)

how to convert blank fields to zero

Sudha

Registered User.

HiTechCoach

Well-known member

MSAccessRookie

AWF VIP

Similar threads

Users who are viewing this thread