conditional format based on other control

  • Thread starter Thread starter RipperT
  • Start date Start date
R

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
 
RipperT said:
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?
Click to expand...


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

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
 
RipperT said:
So if I wish to change the font color in combo1 whenever text2 is not null,
what might that expression look like?
Click to expand...


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

Not IsNull([Text2])
 
Thank you!

Rip
Marshall Barton said:
RipperT said:
So if I wish to change the font color in combo1 whenever text2 is not
null,
what might that expression look like?
Click to expand...


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

Not IsNull([Text2])
Click to expand...
 
Back
Top