Error 2176, Setting for this property is too long

J

Jeff

Hello,

I have a List Box in which throught the use of the applications I made is
populated. It works fine.
However after a while this error comes up.

Is it that a List box conly only hold a certain amount of data ? Is their a
work around ? Any other info you can give on this error ?

Any help would be greatly appreciated.

Thank you,
Jeff
 
W

Wayne Morgan

I believe that the Row Source is limited to about 2k characters, including
the semicolon value separators. To go beyond this, the Row Source should be
a query or table. You can also set the Row Source Type to a user defined
function and leave Row Source blank. I'm not sure what the length limit
would be doing this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '2176' The setting for this property is too long. 0
Runtime error '2176' listbox.rowsource too long 1
"Fields Nested Too Deeply" Error in Simple Word Document 5
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
++ List Box - Data Too Long?? ++ 2
error 2176 4
ComboBox.RowSource Property: error '2176' The setting for this pro 0
Error 2176 - Setting for Property too long 1

Top