Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Sep 21, 1999

DataGrid

Question:
I want to extract data from a specific column in a grid control. When the user selects a record in the grid, I want to take the data from the first column of that record and use it in a recordset that opens another form. Should there be a property-like selected item?

Answer:
The data grid acts like other spreadsheet applications. It recognizes which cell is active by the corresponding column and row set in the col and row properties. When you select a cell or row you are, in effect, changing the row and col properties.

In order to access the text of the column, you need to explicitly designate which column contains your data, and then use the Text property of the data grid. The text property corresponds to the text contained in the cell defined by row and col.

So the following code will display the text of the first row:

DataGrid1.Row = 0  ' Rows start at zero
MsgBox DataGrid1.Text
The next trick you have to perform is choosing the correct event to trigger your action. From your question I thought perhaps you'd just want the user to click on a row to fire the event. To do this, I would suggest using the RowColChange event like the following:
Private Sub DataGrid1_RowColChange(LastRow As _
Variant, ByVal LastCol As Integer)
    If Not IsEmpty(LastRow) Then
        DataGrid1.Col = 0
        MsgBox DataGrid1.Text
    End If
End Sub
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date