[AccessD] Error 2176 the setting for this property is too long

There is a TOTAL text length (all "items" combined) of somewhere in the
neighborhood of 2K characters. That is what you are running in to.  You do
not have a log of options.  The most likely is to build a temp table in the
FE and then pull that in to the list as a normal sql statement.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
Sent: Thursday, August 16, 2007 8:22 AM
To: Acces User Group
Subject: [AccessD] Error 2176 the setting for this property is too long

Hi group,

I'm trying to add values to a Listbox (A2K2).

I'm getting the error:
2176 the setting for this property is too long.

I've done some reading and it seems that this error is the result of a value
that is too long. The value that you can add has a max of 256.

So far i've added 1129 items to the listbox. All with values like:
1131;lblDescription;;fAction

Doesn't look like more then 256 chars to me?!
I've also used trim and stuff but that didn't do the trick (didn't think
so). 

Any ideas?

Thnx,
Sander


       
____________________________________________________________________________
________
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when. 
http://tv.yahoo.com/collections/222
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com