XL: Error Using Data Form If Too Many Fields Are Present

• Microsoft Excel for Windows, versions 2.x, 3.x, 4.x, 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 2.x, 3.x, 4.x 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel, when you use the Data Form command, maximum number of fields that you can edit in a database varies by version of Microsoft Excel. The maximum number of fields for each version for Excel is listed in the following table.

   For Microsoft    If the number  You will receive
   Excel version    of fields is   this error message
   -------------------------------------------------------------------

   98               More than 32   Too many fields in the data form.
   97               More than 32   Too many fields in the data form.
   7.0              More than 32   Too many fields in the data form.
   5.0              More than 32   Too many fields in the data form.
   4.x              More than 32   Too many fields in the data form.
   4.x              Exactly 32     Dialog box contains too many items.
   3.0              More than 32   Too many fields in the data form.
   2.x              More than 32   Too many fields in data form.
   2.2 (Macintosh)  Exactly 32     Dialog too large.

RESOLUTION

If you receive any of the error messages listed in the previous table, do one of the following:

• Reduce the number of fields in your database to 31 or 32 (depending on your version of Microsoft Excel).

      -or-
  

• Edit the database directly on the worksheet.

MORE INFORMATION

When you use the Data Form in Microsoft Excel versions 5.0 and later, Microsoft 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 Microsoft Excel versions 4.0 and earlier may not be visible on the screen; they are "pushed" off of the bottom edge of the screen and, therefore, are not accessible for editing.

REFERENCES

For more information about scrolling the data form in Microsoft Excel, query on the following words in the Microsoft Knowledge Base:

   excel and data and form and screen and resolution and fit and display