Wildcard in String

Experts,

I want to write some code in an on exit event procedure that if my field "Job" has an ending of NCR it will change a check box "Closed" to true. I know the * can be used but I'm confused how to call it out. Something like this:

If Me.Job = Me.[Job] "*NCR" Then Me.Closed = True

Any help is always appreciated

NuclearOilAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
if right(me.job,3)="NCR" then me.closed=true
0
 
derekkrommCommented:
If right(Me.Job.Text, 3) = "NCR"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.