Max Wanadoo
max.wanadoo at gmail.com
Thu Jul 30 12:06:35 CDT 2009
Hmm difficult David, without seeing it. What I tend to do is to have the tabs replaced with buttons (make them look similar) and in the main form I have ONE sub form. Depending which button they click, the embedded sub form name is changed and it is then requeried. Effectively this means (for 5 tab items, 5 same-sized sub forms) but each one is only loaded when required (JIT). This also reduces the load time for a form with many tabs with many associated populating of controls on them. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: 30 July 2009 17:59 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows? 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