Microsoft KB Archive/25675

Number of Fields Used in an Excel Data Form PSS ID Number: Q25675 Article last modified on 06-23-1993 PSS database name: W_eXceL

2.x 3.00 4.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

The maximum number of fields in the data form is 32. However, when using the default data form, Excel lists the fields in a column. Because only 16 fields fit on the screen in a column, only 16 fields appear. This applies to versions of Excel earlier than 3.0.

Depending on your video resolution, you can see 18, 22, or 23 fields in the data form using Microsoft Excel 3.0.

More Information:

To display more fields, a custom data form must be created in which you can determine where each field is displayed so you can display all 32 fields. The 32-field maximum results because 32 is the maximum number of fields using the INIT Result field in a user-defined dialog.

Excel draws all fields in the dialog box, although only the first fields are viewable. Another way to use these fields without creating a custom data form is to scroll the window as follows:


 * 1) Define the database and select Data Form.
 * 2) Press ALT+SPACEBAR, M.
 * 3) Repeatedly press the UP ARROW key. (The number depends on the number of fields.)
 * 4) Press ENTER.

The data form window is now scrolled up so that another screen of fields are both viewable and usable. The top of the data form is no longer viewable. (To return to normal view, press ALT-SPACEBAR, M, DOWN ARROW multiple times, and ENTER.)

For more information, please see the “Database” index entry in the “Microsoft Excel User’s Guide” for version 3.0 or the “Microsoft Excel Reference Guide” for versions 2.x.

Additional reference words: 2.0 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00 4.0 4.00

Copyright Microsoft Corporation 1993.