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

Hahaha, thnx John.

I was afraid of that.
I've created a work around :-)
Manipulated some of the data. Added some data to
another listbox and removed some other et voila...

If this passes UAT I'm going to eat my shoe :-)

Regards,

Sander
--- jwcolby <jwcolby at colbyconsulting.com> wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



       
____________________________________________________________________________________Ready for the edge of your seat? 
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/