Hi Olly
First problem first! It sounds like the built in Conditional Formatting will not do for you, so you will have to rely on the overlaid box technique.
Lets say you just want to change the colour of the text to start with. Lets say the field you want to display is called 'Field1' (I've exhausted my inventivness today) and you want the text to be Blue when Field1 =N and Red when Field1 = D
So, take you original box and copy then past it (so it should retain the same size) Now select one box and change the ForeColor to Red, and change the Control Source data
- =IIf([Field1]="D",[Field1],"")
Now select the second box and change its ForeColor to Blue, Set the Control Source to ;
- =IIf([Field1]="N",[Field1],"")
Oh, I did not say that the Background of these boxes should be Transparent, now if you set their Top values the same they should align and when you run the form you should get the effect you want.
As they are both transparent you should see your highlight bar through them. You may have to bring them to the 'front' (Format > Bring to Front)
I haven't found a way to change the Border colour but you can mess with the background by creating two more boxes, setting their ForeColour as required and using similar code, but instead of displaying the field name you display a series of block-box characters.
=IIf([Field1]="D","█████","")
These two boxes must obviously be set behind the text boxes!
If you use background colours for boxes then this will mess with the continuity of your highlight bar.
I think you have no hope with MouseOver in a continous form but I'll try something and get back.
S7
PS
The display in the forum has inserted "font=Arial" and "/font" in the above but these are not part of the code!
PPS
Then I took them out ;) -NeoPa.