Conditional Format Wild Card - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Conditional Format Wild Card

Brent Rinehart

4 years ago

Can You use wild cards in conditional formatting? for example in a continuous form if I type EX 3421 I want to apply a color and text format, The part that would always change would be the number. So, if the field contains EX and anything else apply the conditional format. I did some searching I'm reading this cannot be done with wild cards, but I know Richard always has a way.

	Kevin Yip @Reply 4 years ago
This can be done by adding a format condition that tests an expression, and the expression is [field1] Like 'EX*' if your field is named field1. See picture below. Wild cards can be used, but according to VBA syntax.

	Kevin Yip @Reply 4 years ago

	Scott Axton @Reply 4 years ago
Very nice Kevin! I just learned something new. Thanks for your input.

	Kevin Yip @Reply 4 years ago
Scott, you're welcome. This can also be done entirely in a VBA module using the FormatConditions object. Expressions can have a wide variety, so you can have many ways to format cells. But if the expression is too complicated it could slow down the formatting.

	Kevin Yip @Reply 4 years ago
Forgot to mention the key thing: the expression needs to have a boolean result; if it evaluates to true, the format is used.

	Brent Rinehart OP @Reply 4 years ago
Sounds good I will give this a try and see how this works thank you

	Brent Rinehart OP @Reply 4 years ago

	Brent Rinehart OP @Reply 4 years ago

	Brent Rinehart OP @Reply 4 years ago
Worked Beautiful Thanks Kevin

	Dan Jackson @Reply 4 years ago
Awesome!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View