Is there any way to highlight a record on a continuous form?? When i try to set the backcolor of a control all controls are set the same color.

what you need is called Conditional Formatting.

Select the object you want to colour and then select Conditional Formatting on the Format menu. Under Condition 1 you can say what the special formatting is and when you want it to apply. You can set up additional conditions if you wish.

I don't think that you can change the background colour of a record in this way but you could get round this by puttinga rectangle under everything else and using conditional formatting on that.



R

You may want to look at this answer I gave for a similar post.

http://p2p.wrox.com/topic.asp?TOPIC_ID=210

It addresses a background color, but you can shrink the "background" to look like a highlighted row. See if you can use it.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Many thanks Greg for this reminder. Missed it first time round.

Clive Astley

Thanks Greg,

This is much easier than alot of the methods I have seen else where!