98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Background colour on report depending upon certain text in a fie
Background colour on report depending upon certain text in a fie
Resolved · High Priority · Version 2007
Fri 19 Mar 2010, 20:10Delegate 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:56Trainer 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:40Delegate 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:21Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Space marksIt 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 |
