I'm not sure how to write this statement.
If [text1]&[Text2]&[Text3] are not null then
I'm sure its easy, but still learning
I'm not sure how to write this statement.
If [text1]&[Text2]&[Text3] are not null then
I'm sure its easy, but still learning
Maybe something like ...
Code:If not isnull(Me.ControlName1.Value) and not isnull(Me.ControlName2.Value) and not isnull(Me.ControlName3.Value) then msgbox "All controls are initialized" else msgbox "One or more controls are not initialized" end if
Thank You ItsMe,
Perfect
You bet. Also, you can use parenthesis around a comparison operator to indicate precedence. For instance us the OR operator and apply that first.
I think it would look something like this ...Code:If (not isnull(Me.ControlName1.Value) OR not isnull(Me.ControlName2.Value)) and not isnull(Me.ControlName3.Value) then