Just a quick thought in the middle of things here but does soundex work ? Al
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Not quite what I was after but very pretty all the same. I can put it to good use elsewhere if that's OK with you. The list box is almost the height of the form which automatically sizes to the available application screen. There is a text box above which is were I want to be able to type in the Stock Code. The Stock code is formatted, Company i.e. "AWG" + Year "09" + Stock No "2" + "a Suffix i.e. "UN" which gives "AWG09-2-UN" or "AWG09-1432-UN" I can look for the code in the cursor "TempStock" and then set the list box's "ListIndex" to the record no but, It I don't always locate the record correctly so it the list box doesn't focus to the right record. I've set Exact off so that it locates the nearest but "AWG08-21" focus's on "AWG08-2-UN". Will pe5rsevere this evening unless anyone has any better suggestions. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
