[AccessD] field limit in forms

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