https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/106206&feed=atom&action=history
Microsoft KB Archive/106206 - Revision history
2024-03-28T18:38:04Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/106206&diff=264028&oldid=prev
X010: Text replacement - """ to """
2020-07-20T09:12:29Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 09:12, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l62">Line 62:</td>
<td colspan="2" class="diff-lineno">Line 62:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>On page 371 of the <del style="font-weight: bold; text-decoration: none;">&quot;</del>User's Guide,<del style="font-weight: bold; text-decoration: none;">&quot; </del>version 5.0, the note at the bottom of the page implies that you can view the first 32 fields of a database that contains more than 32 fields. This note may be misleading. To use a data form with a database that contains more than 32 fields, you must select fewer than 32 fields before you click Form on the Data menu.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>On page 371 of the <ins style="font-weight: bold; text-decoration: none;">"</ins>User's Guide,<ins style="font-weight: bold; text-decoration: none;">" </ins>version 5.0, the note at the bottom of the page implies that you can view the first 32 fields of a database that contains more than 32 fields. This note may be misleading. To use a data form with a database that contains more than 32 fields, you must select fewer than 32 fields before you click Form on the Data menu.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l83">Line 83:</td>
<td colspan="2" class="diff-lineno">Line 83:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== MORE INFORMATION ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>When you use the Data Form in Microsoft Excel versions 5.0 and later, Microsoft Excel <del style="font-weight: bold; text-decoration: none;">&quot;</del>wraps<del style="font-weight: bold; text-decoration: none;">&quot; </del>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 <del style="font-weight: bold; text-decoration: none;">&quot;</del>pushed<del style="font-weight: bold; text-decoration: none;">&quot; </del>off of the bottom edge of the screen and, therefore, are not accessible for editing.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>When you use the Data Form in Microsoft Excel versions 5.0 and later, Microsoft Excel <ins style="font-weight: bold; text-decoration: none;">"</ins>wraps<ins style="font-weight: bold; text-decoration: none;">" </ins>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 <ins style="font-weight: bold; text-decoration: none;">"</ins>pushed<ins style="font-weight: bold; text-decoration: none;">" </ins>off of the bottom edge of the screen and, therefore, are not accessible for editing.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/106206&diff=49515&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:04:31Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB106206"></span>Error Using Data Form If Too Many Fields Are Present =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 106206<br />
<br />
Article Last Modified on 8/15/2003<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Excel 97 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q106206<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
In Microsoft Excel, when you use the Data Form command, the 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.<br /><br />
<br /><br />
<br />
<pre class="fixed_text"> For Microsoft If the number You will receive<br />
Excel version of fields is this error message<br />
-------------------------------------------------------------------<br />
<br />
97 More than 32 Too many fields in the data form.<br />
7.0 More than 32 Too many fields in the data form.<br />
5.0 More than 32 Too many fields in the data form.<br />
4.x More than 32 Too many fields in the data form.<br />
4.x Exactly 32 Dialog box contains too many items.<br />
3.0 More than 32 Too many fields in the data form.<br />
2.x More than 32 Too many fields in data form.<br />
2.2 (Macintosh) Exactly 32 Dialog too large.<br />
</pre><br />
<br /><br />
<br /><br />
On page 371 of the &quot;User's Guide,&quot; version 5.0, the note at the bottom of the page implies that you can view the first 32 fields of a database that contains more than 32 fields. This note may be misleading. To use a data form with a database that contains more than 32 fields, you must select fewer than 32 fields before you click Form on the Data menu.<br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
If you receive any of the error messages listed in the previous table, use either of the following methods:<br /><br />
<br /><br />
<br />
* Reduce the number of fields in your database to 31 or 32 (depending on your version of Microsoft Excel).<br /><br />
<br /><br />
-or-<br />
* Edit the database directly on the worksheet.<br />
<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
When you use the Data Form in Microsoft Excel versions 5.0 and later, Microsoft Excel &quot;wraps&quot; 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 &quot;pushed&quot; off of the bottom edge of the screen and, therefore, are not accessible for editing.<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: 5.0 5.00a 5.00c 7.0 7.00a 8.00 97 XL97 XL<br />
<br />
Keywords: kbprb KB106206<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd