Cond Format-finding char within field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REGREGL - 05 Dec 2007 17:08 GMT

I would like to apply conditional formating to a form text field when
non-apha numeric characters are within the fields value (such as "." "," "-"
etc.). Is there a way to search a field for specific characters and apply
conditional formatting to it if those characters are present?

Reply to this Message

Steve Schapel - 05 Dec 2007 18:02 GMT

Regregl,

In the 'Expression Is' box in the Conditional Formatting dialog, you can
enter something like this:
[YourField] Like "*.*" Or [YourField] Like "*,*" Or [YourField] Like "*-*"

I think there is a shorthand way of writing this... I'm not 100% sure,
but I think this will work:
[YourField] Like "*[.,-]*"

Signature

Steve Schapel, Microsoft Access MVP

> I would like to apply conditional formating to a form text field when
> non-apha numeric characters are within the fields value (such as "." "," "-"
> etc.). Is there a way to search a field for specific characters and apply
> conditional formatting to it if those characters are present?

Reply to this Message

REGREGL - 05 Dec 2007 21:41 GMT

Thanks Steve,

That works great!

> Regregl,
>
[quoted text clipped - 10 lines]
> > etc.). Is there a way to search a field for specific characters and apply
> > conditional formatting to it if those characters are present?

Reply to this Message