Solved

Wildcard in String

Posted on 2011-03-01
2
242 Views
Last Modified: 2012-05-11
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

0
Comment
Question by:NuclearOil
2 Comments
 
LVL 15

Expert Comment

by:derekkromm
ID: 35011715
If right(Me.Job.Text, 3) = "NCR"
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35011717
if right(me.job,3)="NCR" then me.closed=true
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question