Cond Format-finding char within field

  • Thread starter Thread starter REGREGL
  • Start date Start date
R

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

That works great!


Steve Schapel said:
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?
Click to expand...
Click to expand...
 
Back
Top