Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  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.

  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

[Edited entry from 6/13/2005]



See all Topics

Labels:


<Doug Klippert@ 3:49 AM

Comments: Post a Comment

Links to this post:

Create a Link