WildCards

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have this on a Unbound control on a Form. It work untill I put *
before and after bar. I need it to do the first option if the word is
"Bar" or "Left Bar" or "Bar Right"...am I using the wrong WildCard.
Thanks
DS




="This Is Station" & " " & [TerminalName] & " " &
IIf([TerminalLocation]="*BAR*","Located At The" & " " &
[TerminalLocation],"Located In The" & " " & [TerminalLocation])
 
KARL said:
Change IIf([TerminalLocation]="*BAR*",
to read IIf([TerminalLocation] Like"*BAR*",

:

I have this on a Unbound control on a Form. It work untill I put *
before and after bar. I need it to do the first option if the word is
"Bar" or "Left Bar" or "Bar Right"...am I using the wrong WildCard.
Thanks
DS




="This Is Station" & " " & [TerminalName] & " " &
IIf([TerminalLocation]="*BAR*","Located At The" & " " &
[TerminalLocation],"Located In The" & " " & [TerminalLocation])
Click to expand...
Click to expand...
Great! Thank You. It Works...!!!!
DS
 
Back
Top