Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

runtime error

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Run-time error 2176

Run-time error 2176

ResolvedVersion 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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.