[MS_AccessPros] Re: Search anywhere in a field

 

Thanks John,

Batch number length varies depending on the product, and serial number may not be entered in some instances! The inclusion of the serial number in the batch number field has only started recently!

In both bases the maximum number of digits is 10.

I think having 2 separate fields (BatchNumber and SerialNumber) will be the first step. Then I'll need to be able to match any part of of the string with the user's entered text, in either or both of those fields. How would the code look if I did this?

__._,_.___

---

Posted by: nigel@pegasusconsulting.co.uk

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___