Hi, I hope this is a quick question Can you tell me if Conditional Formatting overrides Special Effects? I have a set of Comboboxes that have conditional formatting related to fill color and text color. Ive been trying to set the special effects such that non zero data shows as raised and zero data as sunken. Ive made several attempts with no luck. Ive programmatically set the special effects in After Update and On Current but neither works. Thanks in advance for any advice you can offer! Jim Yeske
Donald Blackwell
@Reply 7 months ago
I just did a quick test.
I created a combo box with a list of values: 0;"Zero";1;"One";2;"Two";;"Null"
I then used conditional formatting via the design tab to the foreground and background color depending on the value.
Then I created a procedure in VBA that set the special effect to raised then changed it to sunken if the combo was null.
I called the procedure from the OnCurrent and AfterUpdate Events
When testing the combo box, the conditional formatting changed as expected as did the special effect.
The only place you would likely run into a problem is if it's in the detail portion of a continuous form. Trying to change any field properties other than conditional formatting will change the properties for every row.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
