Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









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



See all Topics

Labels: ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment