Can you use OR in an IF statement?

[Jon123]

this is what I'm trying to achive.

If IsNull(Me.[oldoffset1]) Or (Me.[oldoffset2]) Or (Me.[oldoffset3]) Or (Me.[oldoffset4]) Or (Me.[oldoffset5]) Or (Me.[oldoffset6]) Or (Me.[oldoffset7]) Then


jon

 

[David R]

If (IsNull(Me.[oldoffset1]) Or (Me.[oldoffset2]) Or (Me.[oldoffset3]) Or (Me.[oldoffset4]) Or (Me.[oldoffset5]) Or (Me.[oldoffset6]) Or (Me.[oldoffset7])) Then

...although, if you're actually trying to check for Nulls in any of those, you need to parse that separately.

If (IsNull(Me.[oldoffset1]) Or IsNull(Me.[oldoffset2]) Or IsNull(Me.[oldoffset3]) Or ...

 

[pr2-eugin]

You could, but make sure you apply condition to each field..

If IsNull(fieldName)[COLOR=Red][B] Or IsNull[/B][/COLOR](fieldName2) Then