Too many fields in data form.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pam - 27 Dec 2004 18:29 GMT

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?

Reply to this Message

Nick Hodge - 27 Dec 2004 21:17 GMT

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.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

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

Reply to this Message

Pam - 27 Dec 2004 21:37 GMT

That worked! Thank you Nick.

> Pam
>
[quoted text clipped - 9 lines]
> > columns,
> > or fields! How many is too much?

Reply to this Message