Multiple textbox values checked with if statement (1 Viewer)

mjdemaris

Working on it...
Local time
Yesterday, 17:46
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.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 17:46
Joined
Aug 30, 2003
Messages
36,124
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

Top Bottom