Conditional formating

S

Smiley

Hi,

I know how to do confitional formating in Excel by clicking the wizard. Is
this possible in MS Access ? If so, please directly where to look. I found
example but nothing as to how to do it. I am very green in this. Please
help.
 
F

fredg

Hi,

I know how to do confitional formating in Excel by clicking the wizard. Is
this possible in MS Access ? If so, please directly where to look. I found
example but nothing as to how to do it. I am very green in this. Please
help.
Click to expand...

In Access 2000 or newer....
In Form or Report Design View, click on the control you wish to
conditionally format.
Then click on Format + Conditional Formatting.
Follow the dialog.
 
S

Smiley

Morning Fred,

Thank you. I would do the conditional format base on the value of a box. For
example 1 will turn the background to red, 2 turn to green etc.

Is there any way I would do the formating for the whole record, instead of
just a field, in a continuous form ?

Many thanks,

Rach
 
Top