</ 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">Horizontal Scrolling and Fixed Columns</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="howtousesplits.html">How to Use Splits</a> > Horizontal Scrolling and Fixed Columns</td></tr></table></div> <div id="BodyContent"> <p>Horizontal scrolling is independent for each split. Often, you need to prevent one or more columns from scrolling horizontally so that they will always be in view. True DBGrid provides you with an easy way to keep any number of columns from scrolling at any location within the grid (even in the middle!) by setting a few split properties.</p> <p>As an example, assume that you have a grid with three splits. The following code will "fix" columns 0 and 1 in the middle split:</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">' Hide all columns in Splits(1) except for columns 0 and 1. </span> Dim Cols As TrueDBGrid80.Columns Dim C As TrueDBGrid80.Column Set Cols = TDBGrid1.Splits(1).Columns For Each C In Cols C.Visible = False Next C Cols(0).Visible = True Cols(1).Visible = True <span style="COLOR: #800000">' Configure Splits(1) to display exactly two columns, and disable resizing. </span> With TDBGrid1.Splits(1) .SizeMode = dbgNumberOfColumns .Size = 2 .AllowSizing = False End With </pre> </td> </tr> </tbody> </table> </div> <p>Usually, if you keep columns 0 and 1 from scrolling in one split, you will want to make them invisible in the other splits:</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">' Make columns 0 and 1 invisible in splits 0 and 2. </span> Dim Cols As Columns Set Cols = TDBGrid1.Splits(0).Columns Cols(0).Visible = False Cols(1).Visible = False Set Cols = TDBGrid1.Splits(2).Columns Cols(0).Visible = False Cols(1).Visible = False </pre> </td> </tr> </tbody> </table> </div> <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>