Prev: Comparing data from a subform and form
Next: Populating a field automatically
From: Becky on 30 Apr 2010 22:45
Greetings

Access help says that wildcards are not allowed when using conditional
formatting. Is there any work-around for this? I'd like to apply this
conditional formatting when... Field Value is Like "Area*"

Thanks, Becky
From: fredg on 30 Apr 2010 23:08
On Fri, 30 Apr 2010 19:45:01 -0700, Becky wrote:

> Greetings
>
> Access help says that wildcards are not allowed when using conditional
> formatting. Is there any work-around for this? I'd like to apply this
> conditional formatting when... Field Value is Like "Area*"
>
> Thanks, Becky

Where did you read that?

Try
Conditional Formatting
Expression is
[FieldName] Like "Area*")

The above works for me.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 | 
Pages: 1
Prev: Comparing data from a subform and form
Next: Populating a field automatically