Multiple textbox values checked with if statement

mjdemaris

Working on it...
Local time
Today, 04:32
Joined
Jul 9, 2015
Messages
426
Is it possible to use a single if then statement to check if several textboxes are null?

As in: If isnull([field1], [field2], [field3]) then
run code
else
run code
end if

according to Microsoft, such a statement should work, but that may be in VBA, not with the macro builder.

Thanks.
 
Try

If isnull([field1]) OR IsNull([field2]) OR IsNull([field3]) then

Using AND or OR as appropriate to your needs.
 

Users who are viewing this thread

Back
Top Bottom