listbox values not displaying

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a list box whose row source is a query yet I am only getting one of
the Rows of data on the list box? Currently our of the 5 columns the last is
being displayed.
 
I have a list box whose row source is a query yet I am only getting one of
the Rows of data on the list box? Currently our of the 5 columns the last is
being displayed.
Click to expand...

Your question states "yet I am only getting one of the Rows of data on
the list box" , while the last sentence states "Currently our of the 5
columns the last is being displayed."

What did you mean by "Currently our of"?

Is it the Rows that are incorrect or is it the Columns that are incorrect?

What, exactly, is the list box Rowsource query SQL?
Does the query byitself show all of the correct data?
What, exactly, is the list box ColumnCount property?
What, exactly, is the list box ColumnWidths property?
What Access version are you using?
What Service Packs have you installed?
Did you check the Microsoft Knowledge base for
potential problems with service packs for your version of Access?
What actually shows in the list box?
What should show?
 
Rpettis31 said:
I have a list box whose row source is a query yet I am only getting one of
the Rows of data on the list box?
Click to expand...
Currently our of the 5 columns the last is being displayed.
Click to expand...

What *excactly* do you mean?
Do you mean you're just getting one of five rows displayed in the listbox?

If so, take a look in the properties of the box an look vor "(number of)
columns" or similar.
An when you're there, also take a look on the property "row width" - if
there are values like "0,0,0,0,2.5" of course you just can see te value of
the last row because all the other rows' width is set to 0 and that means
they aren't shown regardless what value "(number of) columns" has.

Volker
 
I am sorry for the poor wording of my question. I am using a linked table in
my database which is an excel spreadsheet. I have a form with a list box
which by using the wizard will list only certain columns, my problem was the
last column was the only one displaying data. I am assuming it is because of
the linked table as I imported the table from the spreadsheet and have no
issues with the list box on the form.
 
Back
Top