How do you change the color font for just one record in a sheet

[Guest]

I am working on a database sheet and want to highlight individual records
with color code. When I go to the format button on the tool bar it changes
the color of the entire database.

 

[jahoobob via AccessMonster.com]

You could use Condtional formatting on a form but you as you've found out you
can't do it on a table. The field(s) you want to highlight on the form have
to have something in them that sets them off. For instance you culd
highlight all the Last Names that begin with "B" or you could highlight all
the Last Names that are "Brown." You could highlight all the Birthdays that
are in the current month. You can highlight the entire record by making a
copy of the criteria field and setting the conditional fromatting of it to a
certain background color and the same font coler and placing it behind the
fields with the data.
If you post back the criteria for highlighting we may be able to help you
more specifically.