=> Too many fields on My Tabular Form

[Rhonda Fischer]

Hello,

I would like to use a Tabular form to past and copy
quantity values for all of my stock items that means
110 fields need to appear on my form. When I use
the wizard to create my tabular form the error msg
returned to me is too many fields!! What is the
maximum number of fields permissable on a form?

Thank you very much
Rhonda

 

[Andrew Smith]

I'm not sure of the maximum number of fields, but there may be a better way
to do what you want. Why not try exporting the query that you are using for
your form to a spreadsheet - this way you don't need the form at all.

(The form is based on a crosstab query isn't it? Please tell me that you
don't have a table with 110 fields in it!)

 

[John Vinson]

Hello,

I would like to use a Tabular form to past and copy
quantity values for all of my stock items that means
110 fields need to appear on my form. When I use
the wizard to create my tabular form the error msg
returned to me is too many fields!! What is the
maximum number of fields permissable on a form?

Thank you very much
Rhonda

Some 700; it's just that the Forms Wizard is too puny to do that many.
You can add the fields manually in form design.

BUT... 110 fields is DOUBLE the size of the largest table I'd ever
want to use. If you have 110 quantities, *your table is incorrectly
designed* - you're embedding a one-to-many relationship in each record
of the table! You may want to consider stepping back and normalizing
your table structure before you get too far down this dangerous path!

Also, copy & paste is NOT a good way to update tables. Update or
Append queries are much more reliable and very simple to use. Where
are you copying data from?