</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">ComponentOne True DBGrid Pro 8</div> <div id="PageTitle"><div id="PageTitleText">Switching between layout types</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="thebasics.html">The Basics</a> > <a href="choosingacolumnlayout.html">Choosing a Column Layout</a> > Switching between layout types</td></tr></table></div> <div id="BodyContent"> <p>If you define a design-time column layout, the grid will <strong>not</strong> automatically change the layout at run time, as it assumes that you want total control of the display. The grid considers you to have defined a design-time column layout if you chose the <strong>Retrieve Fields</strong> option from the grid's context menu or modified any properties in either the <strong>Columns</strong> or <strong>Splits</strong> property pages.</p> <p>You can clear the design-time layout by choosing the <strong>Clear Fields</strong> option of the grid's context menu or by invoking the grid's <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!clearfieldsmethod.htm" target="_self">ClearFields</a> method in code:</p> <div class="FilteredContentCS" data-title="CS" data-itemid="CS"> <table class="SyntaxTable"> <tbody> <tr> <th>Example Title</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> <span style="COLOR: #800000">' Clear column layout. </span> TDBGrid1.ClearFields </pre> </td> </tr> </tbody> </table> </div> <p>After this statement is executed, the grid will again respond automatically to layout changes at run time.</p> <p>Conversely, you can cancel the grid's automatic layout behavior by invoking the grid's <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!holdfieldsmethod.htm" target="_self">HoldFields</a> method in code:</p> <div class="FilteredContentCS" data-title="CS" data-itemid="CS"> <table class="SyntaxTable"> <tbody> <tr> <th>Example Title</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> <span style="COLOR: #800000">' Cancel automatic layout. </span> TDBGrid1.HoldFields </pre> </td> </tr> </tbody> </table> </div> <p>After this statement is executed, the grid will stop automatically changing the layout at run time, and uses the current column layout for all subsequent Recordset display. This is especially useful if you need to refresh the data control the grid is bound to while maintaining the current grid layout.</p> <p>By using the <a href="javascript:TL_1017401.HHClick()">ClearFields</a> and <a href="javascript:TL_1017402.HHClick()">HoldFields</a> methods, you can alternate the grid's display between automatic layout and customized layout.</p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255792-activex-documentation">Documentation Feedback</a> </div> </body> </html>