How can I change the font color in single records

[havasu]

I have a contact table where I would like to change font color on selected
records. However, when I try, the whole table changes to that color. Is there
a way to just choose specific records?????

Thank you

 

[Wayne-I-M]

Hi

Create a form based on the table (its never a good idea to work directly on
the table)

You can either use a few condidtional formats - eg. If the record is a shop
then colour some text blue - if its a house colour it red, etc.
This method is limiting as you can only set so many condidtions.

Another method would be to use a little code on form open.
Set the back colour - fore colour - etc
Even this will be limiting (you can only write so much code) but if there
are only a few criteria it should be ok.

I think (not sure about this) that 2007 has some form of colouring sceem
(like the auto format in excel) you would need to check this out though

 

[havasu]

Thanks Wayne, even in the form it's not that simple. However, I found a way
around it, at least when I am sending it. I can convert it to Excel and then
work on it.
Sure would be better if you could just mark one specific record in the table
with different colors so it's easier to work with it.

 

[Larry Linson]

I'll repeat what Wayne told you: you should be working with your data in a
Form, not directly on the Table. There are too many things that you can do
"accidentally" with bad consequences. One of the primary reasons Forms and
Reports exist, but certainly not the only one, is to allow formatting.

Sure would be better if you were working via Table or Report. And, you'd
have a great deal of flexibility in formatting and choosing colors.

Larry Linson
Microsoft Office Access MVP