Conditional Formatting if the field contains a specific number

N

nbslarson

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.
 
G

Gina Whipp

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

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.
 
D

De Jager

nbslarson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top