troubleshooting Question

Access VBA  Using text-box with like operator

Avatar of rgagli1
rgagli1 asked on
Microsoft AccessVisual Basic Classic
5 Comments1 Solution1010 ViewsLast Modified:
I'm trying to use a form's text-box (Account Number) and use a like in a query.  The user will enter the first 3 digits of an account and the query should pull all the accounts that begin with that value.  For example, on the [Forms]![Account Number]![Digits] value, I want to trim and left only 3 characters.  So in the query, I have L Trim ([Forms]![Account Number]![Digits],3).  But around this I have Like"L Trim ([Forms]![Account Number]![Digits],3)*".  Any suggestions?  The query will not work when referencing this form but it will work if I manually type in like "111*".  


sumerdai.Net Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros