One way to ensure data is accurate in your Access database is to make sure users know the rules for entering data; you can do this by making the rules available as users work with a form. For example, you can create help tips for any control on the form by following these steps:
- Double-click the control.
- Under the Other tab, click in the Control Tip Text property box.
- Type the tip (up to 255 characters).
When the user rolls the mouse over the control, the tip will be visible.
You can also add help tips to the Description cell for each field in the Table design grid; text entered in a description cell automatically appears in the status bar when the user selects a control whose source comes from that field. However, you don't have to go back to the Table design grid to add a help message to the status bar; you can add it at any time in a form's design view by following these steps:
- Double-click the control.
- Under the Other tab, click in the Status Bar Text property box.
- Type the message (up to 255 characters or the space available across the status bar).
Each time the user selects or tabs to the control, the help message will appear in the status bar.
Miss a tip?
Check out the Microsoft Access archive, and catch up on our most recent Access tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
