Conditional Formatting... Sort of

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a text box wherein I want to change the
color of the text depending on the value of
another field. I can't see how I can use
conditional formatting and there's no such
thing, that I know of, as OnFormat with forms.

The O2K form uses continuous mode.

If I can use a function invocation within the
conditional formatting, then I can see how
that would work, but I don't see that I can
do that.

Any ideas?

Bill
 
Set the Conditional Formatting to:
Expression
such as:
[MyOtherField] < 0
and apply the formatting you want.

You are still limited to 3 conditions (so 3 colors).
 
Allen,
Got it, thanks,
Bill


Allen Browne said:
Set the Conditional Formatting to:
Expression
such as:
[MyOtherField] < 0
and apply the formatting you want.

You are still limited to 3 conditions (so 3 colors).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Bill said:
I have a text box wherein I want to change the
color of the text depending on the value of
another field. I can't see how I can use
conditional formatting and there's no such
thing, that I know of, as OnFormat with forms.

The O2K form uses continuous mode.

If I can use a function invocation within the
conditional formatting, then I can see how
that would work, but I don't see that I can
do that.

Any ideas?

Bill
Click to expand...
Click to expand...
 
Back
Top