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

David McAfee davidmcafee at gmail.com
Thu Jul 30 16:24:12 CDT 2009


The Export /import  doesnt fix the problem.

I decompiled, that didnt do it either :(

I think I'm going to just rebuild the form from scratch.

On Thu, Jul 30, 2009 at 1:16 PM, William Hindman <
wdhindman at dejpolsystems.com> wrote:

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



More information about the AccessD mailing list