Change Datagrid Column Value

vietskynet · August 1st, 2008, 03:42 AM

This is my code

Code:

      Set rs = New ADODB.Recordset
       rs.Open "SELECT id,name,address,male FROM members", cn, 1, 3, 1

       Set grdData.DataSource = rs

It's okay but now the column "Male" just show -1 and 0
I want this column will display "Male" or "Female"

I tried this

Code:

      If rs.Fields("male")=Yes Then

      grdData.Columns("male").Text   = "Male"

      Else

      grdData.Columns("male").Text   = "Female"

      End If

But it don't work..