Conditional Formatting expression
the expression I am using for this is:
but for some reason it doesnt seem to be working
Thank you for taking the time to report an issue.
What's wrong... Please write below.
You can set conditional formatting for a text box or a combo box control. You can change the formatting based on the control's own value, or you can use an expression to change the formatting based on the values contained in other fields or controls. On a form, you can use conditional formatting to disable a control, and you can cause the formatting of a control to change when the cursor is positioned in that control.
What do you want to do?:
*Apply conditional formatting to a control based on its own value
*Use an expression to apply conditional formatting to one or more controls
*Change the formatting of a control on a form that has the focus
*Remove conditional formatting from one or more controls
*Create alternating row colors on a report
Two 2003 clients have problems with the conditional formatting. No matter what I put in for an expression it formats as if the criteria is not met even Expression TRUE | or expression 1=1 won't format the controls
The expressions I have work fine for all the other clients (about 20 of them). What settings on that client could cause it to ignore conditional
I am trying to apply conditional formatting to that field so that it turns a different colour if the date is the same as todays date. I have tried using date() in both the expression, and 'is like' section of conditional formatting, but it is notpicking it up becasue of the time value.
I think I need some sort of contains, or find command, but not sure of how to do this
The reason I ask this is that I have a report with quite a few text boxes that currently all have some sort of Conditional Formatting on them (Not all have the same Conditional Formatting). I know that when you only have a few controls that require Conditional Formatting, the built in solution in Access 2007 should be sufficient, however when the number of controls grows and when the report has multiple records that require each control to be handled on each record, the Conditional Formatting becomes very slow (much like receiving 1000 paper cuts) and renders the report as pointless considering a user must run it for 10's of minutes to an hour to complete.
So, with that said, I am really just looking for anyone's suggestion as to whether I should invest some time in the VBA coding to do what the Conditional Formatting does, or do I just go back to the requestor and let them know that formatting all these fields is too much for the system to handle.
In the Person table I have a lookup field called 'EEA Status' which references another table (called 'EEA') with a list of countries in column1 and whether they are EEA or Non EEA in column 2.
On a form I want to be able to change the formatting of the combo box for that record if a NON EEA country is selected. I know I need to use an expression in the conditional formatting, butI can't find an expression that works.
I have an expression:
but it doesn't seem to work
In this article
* Understand conditional expressions
* Create a conditional expression
* Examples of conditional expressions