|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
Form Error Checking: Two Controls Using the Same Keyboard Shortcut
Provided by: Steve Clark, Senior Project Manager
In Microsoft Office
Access 2003, a new feature has been added to help you determine if there are
some common errors in the design view of you form.
These errors are:
1. Unassociated label and control - a label and a non-label control that are not associated.
2. New unassociated labels - a label that is not associated to a non-label control
3. Keyboard shortcut errors - Two labels that share the same hotkey
4. Invalid control properties - A Bad Controlsource string or an two Option Value that share the same value.
To see an example of the error checking in action, try the following:
1. Open the Northwind database.
2. Open the form 'Main Switchboard' in design view.
3. Change the Button caption of 'Print Sales &Reports' to '&Print Sales Reports'. (This changes the Hotkey from 'R' to 'P'. Note that 'P' is already used for the "Products".
After making the change, either a SmartTag will be displayed (if the button is still selected), or if you select a different control, then the upper-left hand corner of each of the button will turn a different color. Clicking on either object will open the SmartTag. If you click on the SmartTag, it will drop down a menu, and at the top of it, it states, "Keyboard Shortcut Errors".
In future tips, we'll explore how to trigger some of the other errors that Access is now designed to catch.
