I have an unbound text/list box that uses a SELECT FROM statement as its record source. It is basically a search results form from the user entering first and last name, but it searches for either instance (first or last name), so if I enter "John Williams" it gives me all the johns and all the williamses. The problem is that the list box doesn't show all the values. It will only return a small set of them (alpha sorted, it sometimes ends on last name C-- or D--- or L-- or M--; random every time). I checked the max records property of the query and everything else I could think of, and it seems that the problem lies in using the scroll bar.
Once the records are returned in the list box, if I scroll through them using the arrow at the bottom of the scroll bar, I can get to the end of the list (Z--) no problem. However, if I try to page down with the scroll bar, the list ends prematurely.
ANY ideas?????
Once the records are returned in the list box, if I scroll through them using the arrow at the bottom of the scroll bar, I can get to the end of the list (Z--) no problem. However, if I try to page down with the scroll bar, the list ends prematurely.
ANY ideas?????
