Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Run-time error 2176

Resolved · Urgent Priority · Version 2003

Reply Mon 11 May 2009, 17:15Delegate 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

For upcoming training course dates see: Pricing & availability

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

RE: Run-time error 2176

Sorry error code is 2176 not 2076

Reply Wed 13 May 2009, 16:55Trainer 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

Access articles

· Microsoft Access Training Opens Doors
· User-Level Security In Access
· Up The Professionalism Of Access Files Thanks To Digital Signatures
· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access 2007: New Features

Please browse our web site to find out more about
access+course+training and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips