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

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).]

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

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.

A2k also has a conditional formatting feature.

Alex

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