98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access VBA Training and help » Run-time error 2176
Run-time error 2176
Resolved · Urgent Priority · Version 2003
Paul has attended:
Access VBA course
Run-time error 2176
Hi,
I am populating a combo box with rowsourcetype "Value List" with a record set of invoice numbers.
While this has worked ok for some time, this form has started generating the error "Run-time error 2076 The setting for this property is too long".
I think it's something to do with how many records I'm trying to put in the list (10 characters but >2000 records).
Please advise.
Thanks
Paul
RE: Run-time error 2176
Sorry error code is 2176 not 2076
RE: Run-time error 2176
Hi Paul
Thank you for your question
Can you clarify the following for me please
1. Which line of code is generating the error?
2. Are you attempting to write the contents of the combo box to a variable?
Thanks
Stephen
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Relationship mapsIt is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes |