Conditional Formatting - Access 2013

[basilyos]

hello

i want to write an expression as a new rule in conditional formating section
but i want that expression to see if TEXTBOX contains "100" so change the colors

but i don't want to use equal because i have many records like
100/101
100/102
100/103
200/201
200/202
.........

so any help?

 

[smig]

Use either instr() function or like *100*

 

[basilyos]

when using like *100* i got this message

the espression you entered conatians invalid syntax
you may have entered a comma without a preceding value or identifier

this is what i wrote
[txtCode] like *100*

 

[basilyos]

smig thank you bro i use instr()

awesome

 

[smig]

Glad I could help.

Sorry, only now i noticed you are t as lking about conditional format.
As you found out already, like wont work for conditional formating, it will only work for queries.