[AccessD] field limit in forms

Susan,

<< except, it was early and the grandbaby is underfoot.>>

  yeah, that certainly could be a bit of a problem.

  Not quite there yet myself (oldest is 21), but I can see it coming<g>.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, December 07, 2007 10:17 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] field limit in forms

You're right -- I absolutely did write that up wrong, didn't I. I apologize.

Yes, I was talking about the field limits on a table or recordset -- no idea

how I got so confused, except, it was early and the grandbaby is underfoot.

Susan H.


> Susan,
>
>  The limit for a form is 745 controls (including group sections).
>
>  The 255 field limit is for the number of fields in a table or a recordset
> (output of a query).  There is no way of changing that and no workaround
> that I'm aware of with DAO.  Not positive on the ADO front.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Friday, December 07, 2007 8:40 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] field limit in forms
>
> Does anyone know of a work around for the 255 field limit in a form? God, 
> I
> can't imagine having a form with that many controls, but...
>
> A reader seems to think there's a DAO/ADO solution to the problem, but I
> don't know of it -- doesn't matter what the recordset's limitations are, 
> you
>
> still have to deal with the form's.
>
> Susan H.
>
> -- 
> 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 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com