If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting if the field contains a specific number
I am working in Access 2003 and have created a database of chefs who
volunteer for our annual event. Over the years, several are repeat volunteers. I am attempting to create a report wherein the "year" field will turn yellow if the information contains the year "2010". Can this be done (and by someone of my limited grasp of Access)? Thank you for any help you can give. |
#2
|
|||
|
|||
Conditional Formatting if the field contains a specific number
nbslarson,
Have you looked at Conditional Formatting? Look under Format on your menu bar. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "nbslarson" wrote in message ... I am working in Access 2003 and have created a database of chefs who volunteer for our annual event. Over the years, several are repeat volunteers. I am attempting to create a report wherein the "year" field will turn yellow if the information contains the year "2010". Can this be done (and by someone of my limited grasp of Access)? Thank you for any help you can give. |
#3
|
|||
|
|||
Conditional Formatting if the field contains a specific number
You might also like to make the yellow conditional on the year field
equalling Year(Date()) rather than 2010. This will mean that it will always be determine by the current year whatever year it is rather than your having to amend the report when you move into 2011 or later. The Date function returns the current date and the Year function the year of the date. You'll notice that Year is the name of a function in the above, so this means Year as a field name should be avoided (similarly Date etc). Its always best to use more specific names like EventYear for object names. Ken Sheridan Stafford, England nbslarson wrote: I am working in Access 2003 and have created a database of chefs who volunteer for our annual event. Over the years, several are repeat volunteers. I am attempting to create a report wherein the "year" field will turn yellow if the information contains the year "2010". Can this be done (and by someone of my limited grasp of Access)? Thank you for any help you can give. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/201003/1 |
#4
|
|||
|
|||
Conditional Formatting if the field contains a specific number
"nbslarson" wrote in message ... I am working in Access 2003 and have created a database of chefs who volunteer for our annual event. Over the years, several are repeat volunteers. I am attempting to create a report wherein the "year" field will turn yellow if the information contains the year "2010". Can this be done (and by someone of my limited grasp of Access)? Thank you for any help you can give. |
#5
|
|||
|
|||
Conditional Formatting if the field contains a specific number
^
Ã*Ã*^£ "nbslarson" a écrit dans le message de groupe de discussion : ... I am working in Access 2003 and have created a database of chefs who volunteer for our annual event. Over the years, several are repeat volunteers. I am attempting to create a report wherein the "year" field will turn yellow if the information contains the year "2010". Can this be done (and by someone of my limited grasp of Access)? Thank you for any help you can give. |
Thread Tools | |
Display Modes | |
|
|