Run-time error 2176

Resolved · Urgent Priority · Version 2003

Mon 11 May 2009, 17:15 Delegate Paul said...

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

Mon 11 May 2009, 17:16 Delegate Paul said...

RE: Run-time error 2176

Sorry error code is 2176 not 2076

Wed 13 May 2009, 16:55 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Relationship maps

It 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

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips