conditional format based on other control

[RipperT]

Hello, all,

Access help states that 'You can set conditional formatting based on (among
other things) an arbitrary expression referencing another control'. I
cannot find any info on how to do this. I would like a field to be formatted
a special way based on the value of a different field. Can anyone expain how
this is done?

Many thanx,

Rip

 

[Marshall Barton]

Access help states that 'You can set conditional formatting based on (among
other things) an arbitrary expression referencing another control'. I
cannot find any info on how to do this. I would like a field to be formatted
a special way based on the value of a different field. Can anyone expain how
this is done?

Sounds like you should use the Expression Is option instead
of the Value Is option.

 

[RipperT]

Sounds like you should use the Expression Is option instead

of the Value Is option.

So if I wish to change the font color in combo1 whenever text2 is not null,
what might that expression look like?
Thank you for taking the time to help.
Rip

 

[Marshall Barton]

So if I wish to change the font color in combo1 whenever text2 is not null,
what might that expression look like?

Using CF on combo1, set he Expression Is: option to

Not IsNull([Text2])

 

[RipperT]

Thank you!

Rip

So if I wish to change the font color in combo1 whenever text2 is not
null,
what might that expression look like?

Using CF on combo1, set he Expression Is: option to

Not IsNull([Text2])