Text Box Forecolor in Datasheet

[AccessPhil]

Can I change the Forecolor of Text Box in Datasheet for every record. For example I have 10 records in Datasheet. I want the 9 records to have black forecolor and the other one with red forecolor. Please somebody help me. Thanks.

 

[bjackson]

Have you tried to use conditional formatting

in design view of your form select the field you want to format

then select of the tool bar Format

select conditional format and away you go

 

[AccessPhil]

Bjackson,

Thanks for your reply.
I'm using MS Access 97. Is conditional formatting already a feature of this version?


Thanks,
AccessPhil

 

[bjackson]

i dont think 97 has this facility, you may be out of luck

sorry i cant help you with your problem

 

[AccessPhil]

Bjackson,

Thanks anyway.


AccessPhil

 

[Rich]

What data type do you want to change the fore colour of

 

[qwkslvr1999]

You might want to try this:
http://www.mvps.org/access/forms/frm0024.htm