Microsoft KB Archive/214303

= XL2000: Error Using Data Form If Too Many Fields Are Present =

Article ID: 214303

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214303





SYMPTOMS
In Microsoft Excel 2000, when you use the Data Form command, the maximum number of fields that you can edit in a database is 32. When there are more than 32 fields, you receive the following error message:

Too many fields in the data form.



RESOLUTION
To work around this problem, use either of the following methods:
 * Reduce the number of fields in your database to 32.

-or-
 * Edit the database directly on the worksheet.



MORE INFORMATION
When you use the data form in Microsoft Excel versions 5.0 and later, Excel wraps the edit boxes in the data form so that all edit boxes are visible on the screen. Because earlier versions of Microsoft Excel do not do this, edit boxes in data forms in Excel versions 4.0 and earlier may not be visible on the screen; they are "pushed" off the bottom edge of the screen and, therefore, are not accessible for editing.

Additional query words: XL2000

Keywords: kbprb KB214303

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.