Hi
how can i make sure that when a user click in the dbgrid it will let the user select a whole column rather then just one filed in a table?

my current code looks like this

Private Sub DBGrid1_click()

On Error Resume Next

MSFlexGrid1.Col = DBGrid1.Col
MSFlexGrid1.Row = DBGrid1.Row

MSFlexGrid1.Text = DBGrid1.Text



End Sub

the above code only let me select one field and display it on msflexgrid, what i want is to let the user select a whole column of data in a dbgrid when they click on it