Change datagrid Column Value

[vietskynet]

This is my 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 okey but now the column "Male" just show -1 and 0
I want this column will display "Male" or "Female"

I tried this

If rs.Fields("male")=Yes Then
grdData.Columns("male").Text   = "Male"
Else
grdData.Columns("male").Text   = "Female"
End If

But it don't work..

[MikeTheBike]

This is my 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 okey but now the column "Male" just show -1 and 0
I want this column will display "Male" or "Female"

I tried this

If rs.Fields("male")=Yes Then
grdData.Columns("male").Text   = "Male"
Else
grdData.Columns("male").Text   = "Female"
End If

But it don't work..

Hi

On the basis that 'male' is a Yes/No field the I suggest this

If rs.Fields("male") Then
    grdData.Columns("male").Text   = "Male"
Else
    grdData.Columns("male").Text   = "Female"
End 

on the basis that it is True or False.

I always think Yes/No is a stupid name for what is realy a boolean variable/field.


MTB