how to change 0 default value to blank when new record opens

[nightangel73]

Okay I need that when a new record opens for data entry that the numeric fields are blank. Now when I open a new record the numeric fields have a 0 default value and this could create error when user is entering new data as they have to delete the 0.



Many thanks
Marilia

[RuralGuy]

The table properties has a Default value for that field. To what do you have that property set?

[nightangel73]

The table properties has a Default value for that field. To what do you have that property set?

The default property is blank so I don't know why it does it. I think it is because it is access 2007

[lfpm062010]

To set 0 to be the default value. Just type 0 in the default value property.
Currently it is set to NULL. To select them just use criteria "IS NULL".

[nightangel73]

To set 0 to be the default value. Just type 0 in the default value property.
Currently it is set to NULL. To select them just use criteria "IS NULL".

I do not want 0 I want it blank so that the user enter the value

[RuralGuy]

The default property is blank so I don't know why it does it. I think it is because it is access 2007

Hmm...how about the default value in the control on the form? Is it set to anything? We can fix it with code if everything else fails.

[nightangel73]

Hmm...how about the default value in the control on the form? Is it set to anything? We can fix it with code if everything else fails.

Okay I set the default value to Null and it works except in one form arggghh

[RuralGuy]

Look at the properties of the control on that form. Where did you set the default value? Table, Form?

[nightangel73]

Look at the properties of the control on that form. Where did you set the default value? Table, Form?

I set the default value at the text box on the form to Null

[RuralGuy]

And it didn't work on one of your forms, right?

[nightangel73]

And it didn't work on one of your forms, right?

Yes, only in own form it didn't work. Don't know why. The only thing that is different in this form is a text box that has a dLookup routine

[RuralGuy]

What kind of a "DLookup routine? Show us please.

[nightangel73]

What kind of a "DLookup routine? Show us please.

Nevermind. I don't think it's going to work. I'm thinking maybe if I can set a command button to do what the lookup function does for the text box I may get rid of the problem. A command button that displays the value in a message box. Thing is the value is not a stored value is calculated value that doesn't get stored (stock in hand).

[nightangel73]

Or is it there another workaround for these annoying 0's on the form. I'm just afraid it will make data entry errors by the users because they have to delete this 0's to enter new data. It sucks! My database is perfect except for this crap.

[nightangel73]

I tried making the text box null when on got focus but it still messes up with the text box with the lookup function.