Use of IIf ...has data in forms

J

JoeA2006

Can IIf ... has data be used in a form field ? I need to set a null field to
zero in subform that has no data.
 
K

Klatuu

Your question doesn't make a lot of sense; however, if you want to change a
Null to anything else, use the Nz() function. To change it to 0
=Nz(Me.SomeControl, 0)
If it is Null, it is changed to 0; otherwise, it is left as is.
 
Top