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."