Changing Colours On From Datasheet View

[s.booth]

Would like to be able to change the colour of text in a field based upon its value (ie. negative in red and positive in black)without affect the same field in other records on the datasheet. Each time I try it it changes the field in all of the records. The field is a calculated field not bound to a field in a table.

Thanks

 

[David R]

If you're using a Continuous Form this is going to be a fact of life I fear. I have the same issue with a subform with additional fields and have not found a way around it.

If someone has figured it out, I would love to know.

Good luck,
David R


[This message has been edited by David R (edited 02-05-2002).]

 

[Rich]

If it's currency then set the Format property to £#,##0.00[Black]"Cr";£#,##0.00[Red]"Dr"
Numeric just remove the currency symbol

 

[Engelking]

This is solved with Office XP. Just right mouse click on the field and choose conditional formating. very easy and pretty slick. Unfortunatly, you must have Access XP though.

 

[Alexandre]

A2k also has a conditional formatting feature.

Alex

[This message has been edited by Alexandre (edited 02-05-2002).]