continuous form with status bar?

[vicsaccess]

ok, i need some help thinking thru how to do what i have thought of. I have a continuous form with a text box we'll call txtstatus with a value from 1-4 for each record on the form. i have 4 unbound text boxes beside the txtstatus that i would like to color according to the value of txtstatus. if the value of txtstatus is 2 then the first two would be green. if txtstatus is 4 then all four would be green. my thought is that i will need to loop thru the records on the form and for each record set this value? not sure, i haven't tried looping records much. does anyone have any direction or examples of what i would like to do?

[pbaldy]

Check out Conditional Formatting.

[vicsaccess]

thought about it but this was more an exercise on learning than something to use. sounded like a good small idea to look at looping.

[pbaldy]

I don't think you can get that look with code on a continuous form. A report yes, not a form.

[vicsaccess]

ok, i actually have something that i need this method for but i need to do some more practice first. will probably need help again once i get started on it