Different font colors for each record in a table...

[Greg]

I have a table with only about 10 records in it. Is there
a way I can assign each record in that table a different
font color? I can't seem to find any way to change the
font color without changing every record in the table to
the same color.

 

[John Nurick]

Hi Greg,

You can't just assign a colour to a record. There must be something in
the data to specify the colour, whether it's the values you already have
(e.g. a different colour for each state) or a field you add for the
purpose.

You'll need to use a form to display the data. In an ordinary "form
view", you can use the form's Current event procedure to adjust the
colour of each control. This won't work in a continuous form; instead,
try Stephen Lebans's solution at
http://www.lebans.com/formatbycriteria.htm

I have a table with only about 10 records in it. Is there
a way I can assign each record in that table a different
font color? I can't seem to find any way to change the
font color without changing every record in the table to
the same color.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.