Private Sub Form_Load()
strSQL = "select cardid,name,userid,iif(sex,'男','女') as ssex,sex from users"
Set rs = db.OpenRecordset(strSQL)
Set Data1.Recordset = rs
End Sub
Private Sub DBGrid1_ButtonClick(ByVal ColIndex As Integer)
Dim mybm
mybm = DBGrid1.Bookmark
rs.Edit
rs!sex = Not rs!sex
rs.Update
rs.Requery
DBGrid1.Bookmark = mybm
DBGrid1.Col = 3 'boolean所在列
End Sub