Is it possible in Access 2013 to have an entry tip (like a tool tip) which will be displayed as soon as one enters a text field to enter data? The tip will inform what kind of data is required to be entered in the field.
[FieldHelp] = "Enter the part number in nnn-nnnnn format."
{OR}
[FieldHelp] = "Select the correct size from the drop-down list."
{OR}
[FieldHelp] = "Check this box to indicate that the shipment requires special handling such as a FRAGILE tag."
Is it possible in Access 2013 to have an entry tip (like a tool tip)
Hi. You could try using the Format property of the Textbox to provide the info when the value is Null.
I blogged about something which might be of interest on my website here:-
Display a Message for the User - Nifty Access
Display a Message for the User There are many ingenious ways to offer help to your MS Access Application user. In a help table in a Text Box. There is a YouTube video by way of explanation here, and a downloadable example database. Display Message inside TextBox Display a Message for the User...www.niftyaccess.com
I do the same as the Doc but using a MouseMove event.
To clear the help message, I use an empty string in the MouseMove event for the form's Detail section
What I did was I reserved a "FieldHelp" text box on my forms. (I had the screen space for it.) For each data-entry or data-selection control, the "GotFocus" routine did something like
Code:[FieldHelp] = "Enter the part number in nnn-nnnnn format." {OR} [FieldHelp] = "Select the correct size from the drop-down list." {OR} [FieldHelp] = "Check this box to indicate that the shipment requires special handling such as a FRAGILE tag."
In the corresponding "LostFocus" event I erased the box.
I blogged about something which might be of interest on my website here:-
Display a Message for the User - Nifty Access
Display a Message for the User There are many ingenious ways to offer help to your MS Access Application user. In a help table in a Text Box. There is a YouTube video by way of explanation here, and a downloadable example database. Display Message inside TextBox Display a Message for the User...www.niftyaccess.com
I am unable to locate the downloadable sample
Private Sub Units_GotFocus()
Me.Label2.Caption = Units.Tag
End Sub
The Tip-Text for each text box can be saved in their Tag Property and display it in a Label Caption, in the footer/Header of the Form, on the GotFocus() Event:
Code:Private Sub Units_GotFocus() Me.Label2.Caption = Units.Tag End Sub