Conditional Formatting Back Color (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 06:00
Joined
Dec 6, 2010
Messages
608
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

I’m here to help
Staff member
Local time
Today, 03:00
Joined
Oct 29, 2018
Messages
21,358
Maybe you could either post some screenshots or a demo version of your db to help explain the issue?
 

JamesJoey

Registered User.
Local time
Today, 06:00
Joined
Dec 6, 2010
Messages
608
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
 

Attachments

  • conditionalformatting.accdb
    576 KB · Views: 438

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:00
Joined
May 7, 2009
Messages
19,175
is this more acceptable?
 

Attachments

  • conditionalformatting.accdb
    928 KB · Views: 480

JamesJoey

Registered User.
Local time
Today, 06:00
Joined
Dec 6, 2010
Messages
608
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

..forever waiting... waiting for jellybean!
Local time
Today, 18:00
Joined
May 7, 2009
Messages
19,175
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

Registered User.
Local time
Today, 06:00
Joined
Dec 6, 2010
Messages
608
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
 

Users who are viewing this thread

Top Bottom