Text Message in Access form when tabbing through

[stirlsa]

I want to create an event procedure in ACCESS under 'Events' to display a message on a form when the user gets to a certain field by tabbing.

1. Would 'On Got Focus' be the correct item to use? I tried in Code Builder to add the following text in the On Got Focus for the Check Box, but when I do the following, save it and tab through the form, nothing happens when I tab to that field.

Private Sub Check57_GotFocus()
Text = "You can use the space bar to easily select or deselect the check box."
End Sub

 

[gauntletxg]

What you are basically doing with that line of code is setting the value of an undeclared variable equal to the message you want to send to the user. I think what you want is:

Private Sub Check57_GotFocus()
MsgBox "You can use the space bar to easily select or deselect the check box."
End Sub

Or a less obnoxious method would be

Private Sub Check57_GotFocus()
Dim status As Variant
status = SysCmd(acSysCmdSetStatus, "You can use the space bar to easily select or deselect the check box.")
End Sub

Private Sub Check57_LostFocus()
Dim status As Variant
status = SysCmd(acSysCmdClearStatus)
End Sub

 

[stirlsa]

Thank you! Both solutions work perfectly!