Conditional Formating..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Warrio - 28 Oct 2005 21:42 GMT

Hello!

Is it possible, in the conditional formatting settings of a textbox, to
enter a logical expression, since it's looking for a true result to be
executed? i.e.. Field Value Is - equal to - mid(myField,1,5) =
"Hello"

Thanks for your help!

Reply to this Message

Marshall Barton - 29 Oct 2005 00:33 GMT

>Is it possible, in the conditional formatting settings of a textbox, to
>enter a logical expression, since it's looking for a true result to be
>executed? i.e.. Field Value Is - equal to - mid(myField,1,5) =
>"Hello"

You can do that, but you have to use the Expression Is
option instead of Value Is.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Warrio - 31 Oct 2005 09:34 GMT

Thanks!

>>Is it possible, in the conditional formatting settings of a textbox, to
>>enter a logical expression, since it's looking for a true result to be
[quoted text clipped - 3 lines]
> You can do that, but you have to use the Expression Is
> option instead of Value Is.

Reply to this Message