</ 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">Reading cell data from non-current records</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="databaseprogrammingtechniques.html">Database Programming Techniques</a> > <a href="accessingandmanipulatingcelldata.html">Accessing and Manipulating Cell Data</a> > Reading cell data from non-current records</td></tr></table></div> <div id="BodyContent"> <p>You can read cell data from non-current rows by using the <a href="javascript:TL_1019438.HHClick()">Column</a> object's <a href="javascript:TL_1019439.HHClick()">CellText</a> and <a href="javascript:TL_1019440.HHClick()">CellValue</a> methods. Note that you can only read data from non-current rows; you cannot update them. (The <a href="javascript:TL_1019441.HHClick()">Text</a> and <a href="javascript:TL_1019442.HHClick()">Value</a> properties are used to read and write values within the current row.)</p> <p>To examine cell data in any row, where bkm is the bookmark of the desired row:</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> ,pre>RowText$ = TDBGrid1.Columns(ColIndex).CellText(bkm) RowValue = TDBGrid1.Columns(ColIndex).CellValue(bkm) </pre> </td> </tr> </tbody> </table> </div> <p>The <a href="javascript:TL_1019443.HHClick()">CellText</a> method returns a formatted string (according to the column's NumberFormat property) exactly as it appears in the cell. The <a href="javascript:TL_1019444.HHClick()">CellValue</a> method returns the unformatted cell data as a string variant.</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>