Simple Conditional Formatting Question

  • Thread starter Thread starter Roger87
  • Start date Start date
R

Roger87

Hi Folks,

:confused: I have a Receiving Inspection database for all of the
components we receive here. I need to be able to change the color and
font in a particular field to highlight specific inspection
instructions for only certain parts. I basically understand conditonal
formatting but cannot figure out how to use wildcards (then again this
might not be the best way to do this).

For instance...If in the special instructions the data starts with "!"
it would have the conditonal formatting applied to it. I tried: Field
Value is - equal to - !* but this doesn't work for data that starts
with a "!" only an exact match of "!*" works. What exactly am I doing
incorrectly here?

Any ideas, suggestions or direction given would be greatly appreciated.
Thanks so much. :D
 
Try

Select Case Left([Field Value],1)
Case "!"
Do This
Case "?"
Do This
Case Else
Do This
End Select

And don't try to use the tab key when responding to
messages or you will be thrown out of the text bos and
send an incomplete message. ;~}
 
:) Thanks JohnR for the information. However, when I tried to enter in
your statements, it gives me all kinds of Syntex errors. :confused: I'm
assuming that I'm making Condition 1 an "Expression Is" and then
entering the information to the right of the drop down box in the text
field. I'm sure I'm missing something obvious, but I can't figure it
out. If you could point me in the right direction I would be very
grateful. Thanks again. :D
 
:( Does anybody here know how I can use this expression in the
Conditional Formatting box? Please...I really need some help with this
thanks.
 
Back
Top