[AccessD] field limit in forms

Hi Susan,

I had to do this once - I initially had 270 fields.  I did a redesign of my
form to reduce the quantity.

Essentially, instead of having several checkboxes, I replaced those with a
field that carried numeric values - each value (1,2,3 . . .) stood for
something different.  

Also, somewhere there is a number sequence in which the later numbers
represent all possible combinations (additive) of the previous number.  MS
uses this for attributes, but I don't know where to point you on that.  

I like Gustav's idea too - you can put subforms on a form and display them
so that users don't know it's not the main form.

Good Luck!
Dan

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