Background colour on report depending upon certain text in a fie

Resolved · High Priority · Version 2007

Fri 19 Mar 2010, 20:10 Delegate Kieran said...

Kieran has attended:
No courses

Background colour on report depending upon certain text in a fie

I am trying to work out how to make a background of a cell on a report a particular colour depending upon the input in one particular field.

An example of what I'm trying to do would be if I had a database listing peoples political party, and I wanted it to correspond: So people who are Labour would be red, Liberal Democrat would be Yellow, Conservative Blue, etc.

How do I do this?

Mon 22 Mar 2010, 11:56 Trainer Stephen said...

RE: Background colour on report depending upon certain text in a

Hi Kieran

Thanks for your question

can you clarify for me whether you are working in Excel or Access. You post mentions changing a cell colour but also refers to the contents of a field.

If you are working with excel, then we need to look at conditional formatting. if this is the case then i also need to know if you are using 2003 or 2007.

Thanks

Stephen

Mon 22 Mar 2010, 21:38 Edited on Mon 22 Mar 2010, 21:40 Delegate Kieran said...

RE: Background colour on report depending upon certain text in a

Hi Stephen

It is Access 2007 I am using.

An example of what i am trying to do is I have a database, which lists requests, as well as submitted date, due date, completed date etc. I would like to somehow highlight in a report that this item is overdue, ideally by highlighting it in some way.

I hope this provides some clarification as to what I'm after.

Thanks for your help
K

Mon 29 Mar 2010, 15:21 Trainer Stephen said...

RE: Background colour on report depending upon certain text in a

Hi Kieran

Thanks for the clarification.

It might be possible to use the conditional formatting tool in Access 2007. Open the form in design view and select the field to be formatted.
The conditional format tool is found in the Font group. Simply activate it and then select the criteria required as well as the formatting. In the example you give simply set the due date filed to less than and Date(). This should then change colour when the current date is after the due date.

Regards

Stephen

Mon 5 Apr 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips