Highlight Form Data

Show your position

Conditional formatting, in Access, has one more alternative than Excel. Besides "Field Value Is" and "Expression Is", there is "Field Has Focus". You can call attention to the location of the insertion point.

1. In Design View, in the Detail section, click the Control box.
   
2. On the Format menu, click Conditional Formatting.
   
3. Under Condition 1, chooseField Has Focus in the first box.
   
4. Click the arrow next to the Font/Fore Color button, click the yellow box, and then click OK.
   
   
   
   
5. On the File menu, click Save.
   
6. On the View menu, click Datasheet View to view the results.

Also see: Using the Value in a Control as Formatting Criteria and Using an Expression as Formatting Criteria Microsoft Office Online: Highlighting data for impact on a form in Access



See all Topics