List box problem

  • Thread starter Thread starter Bob Scott
  • Start date Start date
B

Bob Scott

As per my earlier post here's the SQL statement for the query you requested:
SELECT tbl_Vendors.Vendor_ID, tbl_Vendors.Vendor_Name,
tbl_Vendors.Vendor_Number, tbl_Vendors.Bid_Name,
tbl_Vendors.Agreement_Number, tbl_Vendors.Phone_1, tbl_Vendors.Phone_2,
tbl_Vendors.Fax, tbl_Vendors.Contact_1, tbl_Vendors.Contact_1_Cell,
tbl_Vendors.Contact_2, tbl_Vendors.Contact_2_Cell, tbl_Vendors.Comments
FROM tbl_Vendors
ORDER BY tbl_Vendors.Vendor_Name;
It returns all records. I have also used the table as a row source but I
still don't see all the records in the list box. The weird thing is that if
I reduce the font size I see more records and changing the size of the box
effects how many records are displayed.
 
Does the list box show a horizontal and a vertical scroll bar?

I've never had a problem with a list box showing only some records and then
having the number of records dependent upon the font size.
What are the fields defined as in the table? Perhaps you're exceeding the
maximum number of bytes per record that you can have in a query?
 
Just to eliminate the obvious, is the OP sure that the number of columns
in the ListBox matches the number of columns returned by the query?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top