MouseMove Event

We have a survey form with option buttons to Excellent, Good, Bad Not Acceptable. We need to criteria behind each of these option to ensure that the correct selection is made. For example "Excellent" might be based on "The equipment is clear of defects, is clean and does as required"

This criteria is based in the same table as the question, with a field for each of the Reponses.

Currently we have 4 text (memo) controls on the form, with the criteria for each selection. My problem is that this criteria is dominating the form, as sometimes it can be paragraphs long.

Is it possible to have a single, unbound control, that displays the relevant criteria when hovering over each of the selectons? Acting very much as a ControlTip Text would.

Yes, but to do so, you must use the MouseMove event of each of those radio buttons, and then to make sure that the text disappears when you are not over one of those buttons, you must use the mousemove event of the frame they are in (if they are in a frame) or of the detail section to reset the text in that control.

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…

In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…

With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…