[AccessD] field limit in forms

Susan,

Again a simple answer:  that's what one-to-one relationships are for.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, December 07, 2007 7: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