[AccessD] field limit in forms

It's simple, Susan:  subforms.  Break the controls up among subforms,
because each subform only counts as one form.  You'll have to create a
new parent to do this, because AFAIK there's no way to reset the counter
on controls.

Of course, then you have to deal with concurrency issues among the
subforms .... ;->

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 5: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