Runtime error '2176' listbox.rowsource too long

  • Thread starter Thread starter Your name
  • Start date Start date
Y

Your name

I am getting a "Runtime error '2176'". The setting for this property is
too long. When I clcik on the "Debug" button - it takes me to the line
where I set the listbox.rowsource property equal to my query.


The query returns ~ 500 rows (I can go to the "Query" tab and paste the
query in - it runs fine - NOT a syntax problem). Each row is approx 80
bytes. I am trying to add these 500 rows to a list box. I thought the
limit on number of rows is 32767 in a listbox.

Is this 32767 the total number of bytes in the list box? Since 500 rows *
80 bytes / row > 32767 bytes - is this my problem?

Any suggestions? Use another control?

Thanks,
Ray
 
Do you mind telling us the Row Source Type? Are you using a value list? If
your type is a query or table, you should not have any issues.
 
Back
Top