Philipe Avelar
asked on
Can I recreate conditional formatting using VBA?
I've found that the conditional formatting on my Access report doesn't consistently work when using the Access runtime (instead of the full version of Access). My next logical step was the try to recreate the conditional formatting through VBA. i put the code to change the background colors of my text box in the Paint event of the Group Header that the text box is in. When i run this report, the conditional formatting works, but the text box flickers like crazy. The flickering makes the report unusable.
Is there a better way to solve my problem? Any help would be greatly appreciated. I've been wrestling with this problem for a couple of days now.
Is there a better way to solve my problem? Any help would be greatly appreciated. I've been wrestling with this problem for a couple of days now.
There's no difference in the Runtime version versus the Full version, so your issue may very well be somewhere else.
What does not work in the runtime, in regard to formatting?
What does not work in the runtime, in regard to formatting?
ASKER
Hi, Scott. Thank you for taking time to look at my question.
I'm not sure why or how i deduced that the runtime was my issue. i think it just made sense to me at the time and maybe that is the real problem i should be looking at here.
i created a report using the full version of Access. That report is being displayed on a computer that only has the Access runtime installed. On that computer, the conditional formatting for a text box on that report will sometimes not display at all. When it does display, the formatting is perfect. It's really inconsistent and tends to only happen to one instance of that text box in the entire report. When i open the same report on my desktop, the conditional formatting works fine.
I'm not sure why or how i deduced that the runtime was my issue. i think it just made sense to me at the time and maybe that is the real problem i should be looking at here.
i created a report using the full version of Access. That report is being displayed on a computer that only has the Access runtime installed. On that computer, the conditional formatting for a text box on that report will sometimes not display at all. When it does display, the formatting is perfect. It's really inconsistent and tends to only happen to one instance of that text box in the entire report. When i open the same report on my desktop, the conditional formatting works fine.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try the following:
Run report on a third computer with only runtime.
Recreate the same report and check on runtime computers.
Create a new report and check on runtime computers.
Uninstall Access from current computer, and run report on same computer in runtime environment.
Run report on a third computer with only runtime.
Recreate the same report and check on runtime computers.
Create a new report and check on runtime computers.
Uninstall Access from current computer, and run report on same computer in runtime environment.
https://blogs.msdn.microsoft.com/frice/2004/06/08/adding-additional-conditional-formatting-in-access-with-vba/
or
https://support.microsoft.com/en-us/help/304104/how-to-programmatically-apply-conditional-formatting-settings-to-all-f