Conditional formating

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

 

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

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.

 

[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

 

[fredg]

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

See
http://www.lebans.com/conditionalformatting.htm