If No Value, Then Zero

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

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)
 
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.
 
Thanks, but I got it, i had the text box named the same as the control
source.


Ken Snell said:
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>

Dave Elliott said:
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)
Click to expand...
Click to expand...
 
Back
Top