Microsoft KB Archive/139970

= BUG:Text & Value Properties of DBGrid Column Show Empty String =

Article ID: 139970

Article Last Modified on 12/9/2003

-

APPLIES TO


 * Microsoft Visual Basic 4.0 Standard Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 16-bit Enterprise Edition
 * Microsoft Visual Basic 4.0 32-Bit Enterprise Edition

-



This article was previously published under Q139970



SYMPTOMS
When using the DBGrid control, attempting to access the Text or Value properties of columns that are not visible on the screen returns an empty string regardless of the actual data in the column.



WORKAROUND
To work around this problem, reference the data directly from the data control instead of from the grid control. For example, instead of using Print DBGrid1.Columns("Telephone").Text to print out the contents of the current record's Telephone field, use Print Data1.Recordset("Telephone") This code prints the Telephone field regardless of whether or not the Telephone column is visible on the screen.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to reproduce problem
 Start Visual Basic, or if it is already running, click New Project on the File menu. In the toolbox, click DBGrid, and drag a new data-bound grid onto Form1. Make the grid approximately 3-4 inches wide. Double-click the data control button in the toolbox to add a data control named Data1 to the form.  Set the following properties of the data control:   Control name   Property         Value =============================================  Data1      DatabaseName      biblio.mdb Data1     RecordSource      Publishers  Set the DataSource property of DBGrid1 to Data1 to bind the grid to the data control.</li> On the Run menu, click Start or press the F5 key to run the program. The application will start and the grid will be filled with data from the Publishers table in the biblio database.</li> Press CTRL+BREAK. On the Run menu, click Break, or click Pause on the toolbar to pause execution of the program.</li> In the debug window type:

Print DBGrid1.Columns("Telephone").Text

The contents of the Telephone field in the database should be printed, however because this field is not visible, an empty string is printed.</li> In the debug window type:

Print Data1.Recordset("Telephone")

The contents of the Telephone field in the database is printed.</li> Continue the program (F5) and scroll so the Telephone column becomes visible.</li> Press CTRL+BREAK. On the Run menu, click Break, or click Pause on the toolbar to pause execution of the program.</li> In the debug window type:

Print DBGrid1.Columns("Telephone").Text

The DBGrid control returns the correct value of "212-869-7440". The correct value is returned because the column is now visible.</li></ol>

Additional query words: 4.00 vb4win vb4all buglist4.00

Keywords: kbbug KB139970

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.