How do I create a message box using macro/code?

T

tarzan123_us

How do I create a message box to appear if the text box remains empty
(meaning user didn't put any values in it)
 
S

Steve Schapel

Tarzan,

The trickiest part of this question is deciding when you want this check
to take place. I guess the Before Update event of the form may be a
likely contender.

If you are using a macro, just make a macro with a MsgBox action, and
enter the required message text. Then, enter the equivalent of this in
the Condition column of the macro design...
[NameOfTheTextbox] Is Null
(if you can't see the Condition column in the macro design window,
select Conditions from the View menu).
Then, close and save the macro, and then assign this macro to the
Property in form design of the event you want it to run on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top