If Any Fields Is Null Return No...

[Ryath]

Hi all,

At the moment i have several fields in my table which contain data but no longer used. To reduce the number of combo boxes, check boxes etcetc on my form i've tried to create a unbound tick box saying that if the certain record has data contained in these fields it would be checked. But with no avail. It simply would not allow me to create it!! wot am i doing wrong??

=IIF(Is Null([Field One] Or [Field Two]),No,Yes)

Can anyone help?

Thank You Will

 

[Gazer44]

Try this:-

If IsNull([Field One]) Or IsNull([Field Two]) Then
[TickBoxName] = 1
End If

 

[Ryath]

Cool... Thx!!! Will