G
Guest
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.
zero in subform that has no data.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.