change color of text in column

[hunterfan48]

I'd like to change the color of the text in one of my columns to red. the column is currency...can I change the color to red?

 

[John Big Booty]

You can do it by setting the for colour property for that field.

Given that this is a currency field, you could use conditional formatting to set the text colour to one colour for positive values and another for negative.

 

[hunterfan48]

where do I set the for colour property for that field????

 

[John Big Booty]

where do I set the for colour property for that field????

Whilst the form is in design view click on the field you want to change and you will find fore colour in the first tab, properties, from memory.

 

[hunterfan48]

ok, I see where you can do that on a form, but how do you change the color of a column in a table?

 

[Rabbie]

ok, I see where you can do that on a form, but how do you change the color of a column in a table?

TAbles are for storing data not for displaying it. Users should not have direct access to tables. Use forms or Reports for showing data

 

[hunterfan48]

so is it not possible to change the color of the txt in one of my columns in a table? that's what I'm asking...

 

[Rabbie]

See my previous post. You shouldn't need to. I don't think it's possible anyway but I could be wrong.

 

[hunterfan48]

ok I did see that...I was jus looking for a direct answer to my question. I appreciate the help. thanks...

 

[Rabbie]

ok I did see that...I was jus looking for a direct answer to my question. I appreciate the help. thanks...

SORRY I thought I was answering your question! Pardon me if i didn't

 

[hunterfan48]

nope, no problem at all...thank you!