Conditional formatting on form

[ngruson]

Hi,

I have a form which is bound to a table. The table contains a few records which are shown on the form. There's also a rectangle in the detail section of the form. The backcolor of the rectangle should depend on the value of a field in the record.

Value field Color


1 Green
2 Blue
3 Orange

Is there a form event which fires per record I can use to accomplish this?

Thanks,
Nils

[RuralGuy]

Every time you move to a different record you will get a FORM Current Event.

[weekend00]

"conditional formatting" is right for you. setup the conditional formatting as you desire then that's it. no need any code or event.

[RuralGuy]

"conditional formatting" is right for you. setup the conditional formatting as you desire then that's it. no need any code or event.

...except I don't believe a rectangle will respond to Conditional Formatting.

[jpkeller55]

Is the rectangle just a color indicator that alerts the users a certain circumstance exits? Could you not just make an unbound text box on the form and size it to the size of your rectangle. Then, you could use conditional formatting on the text box to do what you want. Three conditions for the three differnt colors.

[RuralGuy]

Is the rectangle just a color indicator that alerts the users a certain circumstance exits? Could you not just make an unbound text box on the form and size it to the size of your rectangle. Then, you could use conditional formatting on the text box to do what you want. Three conditions for the three differnt colors.

Is there something wrong with simply using code in the Current event of the form? I'm not trying to be obstinate, just curious.

[jpkeller55]

Nothing wrong from my perspective!

[RuralGuy]

If a poster shows an inclination toward code, I try and encourage this as much as I can. There is so much more available when you know and are comfortable with code that it deserves as much air time on this forum as it can get. I hope you don't mind and I hope the OP continues with code.

[jpkeller55]

You are correct...I agree. Just throwing a low tech solution out there. Take it or leave it.

[RuralGuy]

I don't object to trying to use ConditionalFormatting in this case, just wanted to let you and other know why I responded as I did. Your solution would work as well and thank you for presenting it.

[weekend00]

I tried to use code to do it. But I could not identify the rectangle for each record, they have the same name (just like one column name for all records). for example, the rectangle's name is "box1", when I set box1.backcolor=xx, all rectangles in all records changed.

I am eager to know how to use VBA code to set the box ( or column) in different records.

[RuralGuy]

Well there goes most of this thread. If your form is in Continuous Form view then you will need to use Conditional Formatting as was suggested and a bound TextBox control to boot. It is the only way AFAIK to get individual records in a Continuous Form view to show up differently.