highlight record in a table

[Guest]

Is there a way to highlight or change the font color of only 1 record in a
table? When I highlight that record and change the font color, it changes
the font color for the entire table. Thanks.

 

[Guest]

Why are you working in the table and not off of a form. If it was off of a
form you could code it in based on something. You should never work with
data in tables.

 

[Guest]

Please expand, for those of us who are not designers but only users of
Access. ( I have folks in my office, who design/work the projects but there
still relatively inexperienced despite attending a course) I have people who
are attending a conference depending upon the role of individual at the I
want their record to be displayed in a different colors.

 

[Pat Hartman\(MVP\)]

You can use ConditionalFormatting to highlight individual records. Select
the field you want to format and choose Conditional Formatting from the "?"
menu. Sorry, I've switched completely to the Access2007 beta and can't
remember where anything is in earlier versions.