Pop Up Message

[Guest]

Is it possable to have a pop up message appear when a user clicks into a
field something like "Data Requires Review"? The message would also need to
close when user tabs to next field. Can this be done?

 

[Guest]

Thanks,
Could you direct me to where i can make the code for something like this?

 

[Al Campagna]

acss,
You could use the OnEnter event to trigger a dialog box (MsgBox). The
user would close the dialog box manually.
Or, place your message (Text Control or Label) somewhere on the form, and
make it Visible = No. On the OnEnter, make that Visible = Yes, and OnExit
make it Visible = No. That would require no user intervention at all.

--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[Al Campagna]

Add a Label control to your form and call it lblDataReview, and give it
a Caption of "Data Requires Review" (drop the quotes)
In the Visible property, select NO.

Let's call the Text control you want the Enter and Exit code to trigger
the display of lblDataReview... SomeField

In Design mode...
Place your cursor in the SomeField OnEnter property text box.
Select Event Procedure using the drop down arrow on the right.
Select the 3 dot button on the right (...)
You'll see this....

Private Sub SomeField_Enter()

End If

Now, add this code to that event code...

Private Sub SomeField_Enter()
lblDataReview.Visible = True
End If

Do the same for the SomeField OnExit event, but use Visible = No

Private Sub SomeField_Exit()
lblDataReview.Visible = False
End If
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."