colors in text box

[roamer762]

Hello,

I have a continuous form with text box 1 and text box 2. I need to set text box 1 to red if it is greater then text box 2 and text box 1 to yellow if it is lesst than text box 2. However if i create an event procedure on current (for the form properties) this works only on the first record. I've even tried it on the text box properties but it always works on the first record. I cannot change the form to single or datasheet but have to keep it as continuous.
Can anyone please help?


Thanks

 

[RoyVidar]

Hoping you have versions 2000+, then you can use conditional formatting from the format menu. Use "Expression is" and enter the expression, set a format and...

Roy-Vidar

 

[roamer762]

Unfortunately no i'm using msaccess 97. can you please help?

 

[RoyVidar]

Never done it, some say it's close to impossible, some say it's not. Here are a couple of links that might provide some means of conditional formatting in a97:
Colors and Continuous forms, Changing the Background Color of the Current Record in a Continuous Form

Roy-Vidar