Conditional Formatting

I have a continuous form with 8 text fields on (all in a row). I am trying to get it so that if one of the fields contains the word 'Visit', then the whole row turns a different colour. but only that one row that includes that word. I am guessing I will just have to change the 'detail section' as the controls are individual. I have been playing around with the conditional formatting and can get it to work perfectly for the individual field but not the whole row (i.e. detail), I have tried the following but no joy. any tips?

IIf([ActionType]="Visit",Detail.BackColor=*****)

* I'm not sure which number I am meant to put here; I tried putting #000080 (the type of blue I want) but it kept telling me there was an incorrect date. I took the has out and it just didnt work anyway?

Sponsored Links:

Related Topics

Change the appearance of a control by using conditional formatting
Conditional formatting allows you to selectively highlight certain data on your form or report so that it is easier to understand. For example, you might want to format negative numbers in a red font to make it clear that those records need further attention.
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


Conditional Formatting vs. VBA Formatting
I have been researching this for some time now but haven't received any sound advice on whether it is faster to perform formatting on text boxes in a report via VBA or the built in Conditional Formatting.

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.


VBA conditional formatting
I have read up about conditional formatting and understand the *concept* clearly (I think). However, is it possible to display conditional formatting of a subform in datasheet view on a form? If so, as I need to have more than 3 (or 4 if default is used) colours?


Conditional Formatting through VBA: On Undo
I've moved all my conditional formatting to VBA because of performance issues with Access's built-in conditional formatting facility, but there's one feature I can't replicate. Some of my formatting involves highlighting fields if they're blank.

This works fine for On Current and After Update, but I can't get it to work for On Undo: if I undo changes and thereby leave a field blank, I can't get the conditional formatting to kick in again.

Am I missing something about On Undo, or is there another way of doing this?


Conditional Formatting through VBA: On Undo
I've moved all my conditional formatting to VBA because of performance issues with Access's built-in conditional formatting facility, but there's one feature I can't replicate. Some of my formatting involves highlighting fields if they're blank. This works fine for On Current and After Update, but I can't get it to work for On Undo: if I undo changes and thereby leave a field blank, I can't get the conditional formatting to kick in again. Am I missing something about On Undo, or is there another way of doing this?


Conditional Formatting a date
I am stuck on conditional formatting of a date. A field on a subform is auto populated with the now() command, and gives the following output: 23/01/2012 16:16:17

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


Conditional Formatting in a Sub Report
I'm struggling with a problem I'm having with conditional formatting in an access sub report. I have a main report and 9 sub reports (Monday-Sunday + Total + Targets) each linked to a date on the main form. Each value in the sub reports are compared with the values in the targets sub report and conditional formatting applied.

Basically everything works fine in Report View but conditional formatting disappears in print preview. Any ideas? (Back style is set to Normal


Conditional Formatting Problen
Access 2010, Windows 8 Release Preview

I'm having problems setting the format for the fore color of fields that meet the criteria in conditional formatting. I want the field to be disable. In fact I set the Enabled property for the field to No and the Locked to Yes.

I only want the Fore Color to change if they meet the criteria. But, if I set the field to enabled in the cell formatting the background changes to the back color that is alre4ady set in the formatting.

Is there a way to set conditional formatting without using the Conditional Formatting Rules manager?
I'm using the following as the criteria:


Wrong Fore Color in Conditional Formatting
I'm having problems setting the format for the fore color of fields that meet the criteria in conditional formatting. I want the filed to be disable. In fact I set the Enabled property for the field to No and the Locked to Yes.

I only want the Fore Color to change if they meet the criteria. But, if I set the field to enabled in the cell formatting the background changes to the back color that is alre4ady set in the formatting.

Is there a way to set conditional formatting without using the Conditional Formatting Rules manager?

I'm using the following as the criteria:


Conditional formatting not displayed on report
I have included some conditional formatting on a report of mine. The only time this formatting appears is if I hover my mouse over the formatetd field. It does not appear when simply viewing the report or especially if I print the report. Does anybody know how to have this formatting shown, particularly when the report is printed?


Conditional Formatting on client
I have a report that uses conditional formatting to shade controls It runs without problem on access 2000, 2002, 2003 and 2007

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


conditional formatting
boys, I need help with conditional formatting.
I have two date fields. scheduled date and place.
when the scheduled date is less than today, I put a conditional formatting.
how do I date field when the other place is filled, remove the conditional formatting of the other field.


Highlight values on a report by using conditional formatting
This video walks you through the process of applying conditional formatting to a column of numbers on a report. By using conditional formatting, you can highlight specific values automatically, making your report easier to understand.


Conditional Formatting Access 2007 Form
When attempting to use the conditional formatting button; I am limited to 3 different equal to options. I have several list items in the field and would like to group two or three items in the same conditional formatting. (I.e. Expired, Removed, Deleted all have Gray field with black text.)

I have attempted to use “Expired” Or “Removed and “Expired” And “Removed” but neither option works. Is there a way to use conditional formatting with And\Or statements?


Conditional Formatting Stops Working If Database Moved or Renamed
I have a Form that opens up my database using Autoexec. I have some simple, basic conditional formatting on some of the fields. If field = 0 then the backfill is in green, if the field is >= 1 then the backfill is red.
This has been working fine with no problems in an Access 2007 Database. I have just renamed the file and moved it to another folder and now the conditional formatting no longer works, but in Design View it is still there. I have seen this before when I saved a database to a memory stick and - although the Database worked - the conditional formatting stopped.

I wondered if it might be a problem with the Trust Centre - Trusted Locations? I haveadded my new folder to the list but it doesn't seem to have made any difference.
Can anybody explain why the conditional formatting would suddenly stop functioning?
I've just built a user guide and now the screenshots no longer match the database. Which is quite infuriating!


Conditional Formatting Not Showing
I have added some conditional formatting on a report. I have used Conditional Formatting > If Field Value is Less Than Or Equal to 1 (go green)

I have a value in the report of 0.

When I click on the value in Report view the green shows up however when I click on another value it does not.

Is this a known bug and if so how do I solve it


Conditional Formatting Running Slowly
Can anyone provide any tips for making conditional formatting a bit faster to load? I have a continuous subform with several objects subject to conditional formatting, including a long unbound textbox the length of the row. When I scroll in the subform I find that it takes a couple of seconds sometimes to render the colour changes, particularly with the long text box. I'm using Access 2010 and most of the conditions are simple expressions based on the value of one other field


Conditional Formatting In Forms And Reports
Add various colored text and other formatting to forms and reports in your database, depending upon which conditions are met, even without the conditional formatting feature provided by Microsoft Access 2000 and later versions.


Hide Duplicates + conditional formatting = #NAME
On a report field, I have Hide Duplicates=No AND conditional formatting on that field which depends on a value for this field. I get #NAME as result. If I remove conditional formatting or set Hide Duplicates=Yes, I get the correct data.

I've found this error in other posts, but no answers.


conditional numeric formatting of field output on report
I have a report that uses one area to display either a percentage or a count.

I'd like to format the report field output so that if the value is less than 1 to format the number as a 2 decimal point percent and if it is 1 or greater format it as an integer

the conditional formatting features I see deal with the conditional display format and not the conditional numeric formatting.