Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change font color of one specific field entry

Status
Not open for further replies.

monkeysee

Programmer
Sep 24, 2002
201
US
I have a field in a table that has descriptions of type of inspections done.
Some of the fields are: Routine, Follow-up; Liquor, Opening, etc.
I would like to have the text in the field for Liquor be red, and all the others in the standard black - is it possible to do that?
 
Check Conditional Formatting which provides this functionality. Your question does lack clarity since I don't know if you have a single field with values like: "Routine, Follow-up; Liquor, Opening, etc." or if you have fields with these names as suggested by:
monkeysee said:
Some of the fields are: Routine, Follow-up; Liquor, Opening, etc.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
If the field name is Liquor then right-click | font/fore color and select color

Otherwise what dhookom stated [bigsmile]
If the field is Description and has those in that field, use the conditionally formatting where the field Description = Liquor then select color
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top