If No Value, Then Zero

[Dave Elliott]

On my form this is a bound control which has no value by default and so
shows #error in the field.
How can I make this not show up, I tried this code, it does not work

=Nz([Bid],0)

 

[Ken Snell]

The error that you see likely isn't because the field to which the control
is bound has no "default" value, nor because the control has no default
value. In fact, getting this error suggests that your control isn't bound at
all -- rather, that you're using an expression as its control source.

Post the control source of the control and let's see.

 

[Dave Elliott]

Thanks, but I got it, i had the text box named the same as the control
source.

The error that you see likely isn't because the field to which the control
is bound has no "default" value, nor because the control has no default
value. In fact, getting this error suggests that your control isn't bound at
all -- rather, that you're using an expression as its control source.

Post the control source of the control and let's see.

--
Ken Snell
<MS ACCESS MVP>

On my form this is a bound control which has no value by default and so
shows #error in the field.
How can I make this not show up, I tried this code, it does not work

=Nz([Bid],0)