Solved Continuous Form and Color Code (4 Viewers)

[mloucel]

Hello Gurus...

I have the following form:

My boss has asked me to do the following:

Create 4 boxes
Stat / Approval Date / Appointment Date / Notify Date
I did each one as a text box, thinking I could have done something like this on the On Load Event:

If Stat then StatColor.BackColor = vBRed
If not IsNull AppvalDate then  ADColor.BackColor = vBBlue
if not IsNull AppDate then AppDateColor.BackColor = vBYellow
If not IsNull NotDate then NotDateColor.BackColor = vBGreen

This has to occur for each record that is displayed in the form.

but as you imagine it did not go well.

Can someone point me in the right direction please, if possible with a sample code.

Thanks.

 

[DHookom]

Can the code and use conditional formatting.

 

[MajP]

ke this on the On Load Event:

You can either use conditional formatting or the On Paint event of the detail section.

 

[mloucel]

You can either use conditional formatting or the On Paint event of the detail section.

Yep I was able to do it with Conditional, thou I am curious with the On Paint event, I want to try.

Question, on the On Paint Event then the If Then Scenario will work or dio you suggest something else?

 

[DHookom]

There was a recent discussion regarding the Onpaint. Use the forum search with OnPaint.

 

[MajP]

Example
Post in thread 'Programatically change color on continous form conditional formatting' https://www.access-programmers.co.u...rm-conditional-formatting.323250/post-1827631

 

[mloucel]

Example
Post in thread 'Programatically change color on continous form conditional formatting' https://www.access-programmers.co.u...rm-conditional-formatting.323250/post-1827631

Clever and very interesting, I'm gonna dig in, in the meantime your suggestion works fine, with the Conditional.

Thank you Sir.