Cond Format-finding char within field

[REGREGL]

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?

 

[Steve Schapel]

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 "*[.,-]*"

 

[REGREGL]

Thanks Steve,

That works great!

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 "*[.,-]*"

--
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?