Too many fields in data form.

Pam · Dec 27, 2004

I created new database in Excel and when I click Data, Form I get an error
code that says I have too many fields in data form. I only have 13 columns,
or fields! How many is too much?

Nick Hodge · Dec 27, 2004

Pam

Just check that Excel doesn't think you have more columns than you do, check
here under 'Resetting Excel's UsedRange'

http://www.nickhodge.co.uk/tipstrick.htm

You can have up to 32 fields in a data form.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

Pam · Dec 27, 2004

That worked! Thank you Nick.

Nick Hodge said:
Pam

Just check that Excel doesn't think you have more columns than you do, check
here under 'Resetting Excel's UsedRange'

http://www.nickhodge.co.uk/tipstrick.htm

You can have up to 32 fields in a data form.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]