Unofficial Access Stuff

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

Host your Web site with PureHost!

Monday, July 20, 2015 – 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

See all Topics access
Labels: Customize, Forms, Reference, Tutorials

<Doug Klippert@ 3:53 AM

Comments: Post a Comment