conditional formatting

[lynn atkinson]

Can I set conditional formatting of one field based on the
value in another field?
I want to highlight the course title (eg red text) if the
course has been cancelled (ie field 'cancelled'=yes)

Is this possible through the formatting menu? (I have
never worked in VB)

 

[fredg]

Can I set conditional formatting of one field based on the
value in another field?
I want to highlight the course title (eg red text) if the
course has been cancelled (ie field 'cancelled'=yes)

Is this possible through the formatting menu? (I have
never worked in VB)

Lynn,

If you are using Access 2000 or later you can use the control's
Conditional Formatting property.

Select the control to be formatted.
Click Format + Conditional Formatting

In the Condition 1 Drop-down select
Expression Is

In the text control alongside the drop-down, write:
[Cancelled] = Yes

Select the color.
Click OK.