Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Monday, September 22, 2008 – Permalink –

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.

In Design View, in the Detail section, click the Control box.
On the Format menu, click Conditional Formatting.
Under Condition 1, chooseField Has Focus in the first box.
Click the arrow next to the Font/Fore Color button, click the yellow box, and then click OK.
On the File menu, click Save.
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

[Edited entry from 6/13/2005]

See all Topics

Labels: Access

<Doug Klippert@ 3:49 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link