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

...its 754 over the lifetime ...chk your help file under specifications.
...not tried it but I'd think export to txt might reset this since its 
essentially a new form

William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Thursday, July 30, 2009 2:46 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows?

> I have never heard of this "255 maximum controls regardless of when" 
> thing.  I would not doubt the
> 255 max controls part, it is the tracking of old controls that I would 
> doubt.  But Access has done
> stranger things.  I have no idea where it would store tracking for old 
> deleted controls, however
> given the rename tracking stuff it is probably out there somewhere.
>
> 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
>>>>
>>>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>