Find a string within a string

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I'm strying to update a field based upon the type of email address is in
another field.
In short, if anyone has an email domain like what's in
[DomainString]![DomainString] (below), I'm update with either Text or HTML.
However, I'm not having much luck. I've tried StrComp, InStr, and now
InStrRev.
Anny thoughts?
thanks!

IIf(InStrRev([Import
List]!(e-mail address removed)
 
Hi There,

Should be....

IIf(InStrRev([ImportList]!,[DomainString]!
[DomainString]) > 0,"Text","HTML")

Those darned parenthesis will get you every time...

Regards,
Jen
 
Back
Top