</ 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">Referencing column objects</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="configuringcolumnsatruntime.html">Configuring Columns at Run Time</a> > Referencing column objects</td></tr></table></div> <div id="BodyContent"> <p>When a column is added to or removed from a grid, the associated <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!columnobjectcolumnscollection.htm" target="_self">Column</a> object is added to or removed from the grid's <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!columnobjectcolumnscollection.htm" target="_self">Columns</a> collection. This may cause a change in the index numbers of the existing columns, making it very inconvenient to reference columns numerically. For this reason, True DBGrid also allows you to reference columns using either the <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!datafieldpropertycolumn.htm" target="_self">DataField</a> or <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!captionproperty.htm" target="_self">Caption</a> strings. Thus, the following references are identical:</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">' Reference by the Column index. </span> TDBGrid1.Columns(n) <span style="COLOR: #800000">' Reference by the DataField name. </span> TDBGrid1.Columns(<span style="COLOR: #800000">"LAST"</span>) <span style="COLOR: #800000">' Reference by the Caption string. </span> TDBGrid1.Columns(<span style="COLOR: #800000">"Last Name"</span>) </pre> </td> </tr> </tbody> </table> </div> <p>Referencing column objects by <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!datafieldpropertycolumn.htm" target="_self">DataField</a> or <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!captionproperty.htm" target="_self">Caption</a> is not case-sensitive. TDBGrid1.Columns("LAST") refers to the same column as TDBGrid1.Columns("last").</p> <p>When you reference a <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!columnobjectcolumnscollection.htm" target="_self">Column</a> object and its properties at run time, Visual Basic creates an instance of the object. For example, if you duplicate certain properties of a column:</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> TDBGrid1.Columns(<span style="COLOR: #800000">"First"</span>).Width = _ TDBGrid1.Columns(<span style="COLOR: #800000">"Last"</span>).Width TDBGrid1.Columns(<span style="COLOR: #800000">"First"</span>).Alignment = _ TDBGrid1.Columns(<span style="COLOR: #800000">"Last"</span>).Alignment TDBGrid1.Columns(<span style="COLOR: #800000">"First"</span>).AllowSizing = _ TDBGrid1.Columns(<span style="COLOR: #800000">"Last"</span>).AllowSizing </pre> </td> </tr> </tbody> </table> </div> <p>The Columns("First") and Columns("Last") objects will each be created and discarded three times in the preceding example. The same results are achieved more efficiently by creating object variables that refer to these columns:</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">' Declare Column objects. </span> Dim FirstCol As TrueDBGrid80.Column Dim LastCol As TrueDBGrid80.Column <span style="COLOR: #800000">' Reference First and Last Column objects. </span> Set FirstCol = TDBGrid1.Columns(<span style="COLOR: #800000">"First"</span>) Set LastCol = TDBGrid1.Columns(<span style="COLOR: #800000">"Last"</span>) <span style="COLOR: #800000">' Copy properties from Last to First. </span> FirstCol.Width = LastCol.Width FirstCol.Alignment = LastCol.Alignment FirstCol.AllowSizing = LastCol.AllowSizing </pre> </td> </tr> </tbody> </table> </div> <p>The same technique can be applied to other objects in Visual Basic. For more details, see <a href="http://helpcentral.componentone.com/nethelp/truedbgrid8/#!objectmodel.htm" target="_self">Object Model</a>.</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>