Conditional Formatting Back Color

[JamesJoey]

I'm using a continuous form to display reminders.
I set a Conditional Formatting rule for the fore color of the Reminder field based on the value of
ReminderTypeID.
If the value equals 1 then I want the fore color to be yellow..
The problem is Conditional formatting doesn't allow you to set colors to theme colors.
I have several color themes which change the background color of the continuous for and/or
the background color of the Reminder.
In set the Reminder's Display as Hyperlink set to Screen Only. When click on Reminder an editing form
opens on the record I clicked the Reminder field on.
The issue is when I click on the Reminder, for a second, one sees a white background because
I am unable to set the background color to a color theme I using at the timer.

Can anyone tell me a workaround?
Icon abandon color themes all together or not use conditional formatting here.
I'm not very good at explaining things like this so if you don't quite understand I get.

James

 

[theDBguy]

Maybe you could either post some screenshots or a demo version of your db to help explain the issue?

 

[JamesJoey]

When I click on the reminder on frmDay1 you. can see the result.
I could use the same background color for the reminder as in the form and the conditional formatting butt
if I change color theme it would have as different color

 

[arnelgp]

is this more acceptable?

 

[JamesJoey]

Great!
I never would have been able to implement this.
Although I don't grasp what the code is is doing.
Is it possible for you to summarize the code?

 

[arnelgp]

explain:

it get the first, ConditionalFormat of Reminder Textbox (i think at most 4 conditional format, and it is zero based).
next it change the .Background property of the CF to whatever the background color of the Detail section of your form.

therefore when you change the theme and save the form, the code on the Load event of the form
will get the new background color for textbox Reminder.

 

[JamesJoey]

Ok.
I wanted the ReminderTime to have the same conditional formatting and disabled. So I had to set the background to transparent otherwise
it would display the white background it.

Thanks much,
James