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
|
|||
|
|||
Format Font Color
I have a Data base containing many records. in which there is a Date field
called "Date of Death". I would like to change the Font color to a specific color where the date of death is in the 19th Century and a different color for the 20th century. I have tried to use an update query without success. Can this be done using an Update query or other method? Thanks for any help |
#2
|
|||
|
|||
Format Font Color
You can change the font color of the Control in the Form or on the Report
where you display the information -- Conditional Formatting is probably the simplest approach. It is covered reasonably well in Access 2003 Help. Larry Linson Microsoft Office Access MVP "Roger Bell" wrote in message ... I have a Data base containing many records. in which there is a Date field called "Date of Death". I would like to change the Font color to a specific color where the date of death is in the 19th Century and a different color for the 20th century. I have tried to use an update query without success. Can this be done using an Update query or other method? Thanks for any help |
Thread Tools | |
Display Modes | |
|
|