[AccessD] Has anyone ever sen a listbox not display all rows?

 > Why didn't I think of that....

Speaking of which, I got Eatbloat (my version) populating tables to get around the list control data 
source 2K string length limitation.  I created msys tables in my library container and then populate 
those tables instead of building up a huge comma delimited string for the list control data source. 
  Now the table can hold as many objects as needed and the lists use the tables as their data source.

It just occurred to me that I may need to add "multi-user" handling because my version can 
theoretically be used in many different FEs at the same time.  I'll probably need to track which FE 
the objects are coming from, something like that.

Anyway, it works great so far.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> Why didn't I think of that....
> 
> Max
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 30 July 2009 19:02
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows?
> 
> Export it out to a text file, then import it back in to a new name.  Delete
> the old, rename the new 
> back to the old name.  That might break the spell.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> David McAfee wrote:
>> I have.
>>
>> I've even completely rebuilt it. I think it may be the form that is some
> how
>> corrupt.
>>
>> I remember reading somewhere that a form can only have 255 controls, even
> if
>> its over time (deleting controls, adding controls, deleting controls).
>> I have redesigned this form for a department that didnt know what it was
>> that they want five times.
>>
>> I'm wondering if this somehow could be an issue.
>>
>> I may have to rebuild the whole form...which sucks because it is very
>> complex. :(
>>
>> David
>>
>>
>> On Thu, Jul 30, 2009 at 1:50 AM, Max Wanadoo <max.wanadoo at gmail.com>
> wrote:
>>> David,
>>> Try COPYING a list box that works and then change the attributes to what
>>> you
>>> need.
>>> That sometimes works.
>>>
>>> Max
>>>
>>>