I have a checkbox field called Active, with a yes/no check for whether
a customer is active. Is there a way that I can keep using a
checkbox, but the value isn't yes/no, instead it is
CustomerActive/CustomerInactive?

Can't you just change the label to read whatever your want ?? It's the value
that is stored...Yes/No True/False...

Jack
"Andrew" <AndrewEgan (AT) att (DOT) net> wrote

I could just change the label, but I export this database to Outlook,
which sorts the customers as active or inactive, so I need those terms
exported, as opposed to the words yes or no being exported.



"Jack" <jfeubank (AT) shaw (DOT) ca> wrote

I have had to store T and F in a table, because of another application
that also accessed the data and did not support Yes/No. I controled
the state of the visible control in code with the value in a hidden
field, when the form was opened or the control changed. Something
like this:

Private Sub Form_Open(Cancel As Integer)
If Me!MyHiddenControl = "CustomerActive" Then
Me!VisbleControl = True
Else
Me!VisbleControl = False
End If
End Sub


Private Sub VisbleControl_Change()
If Me!VisbleControl Then
Me!MyHiddenControl = "CustomerActive"
Else
Me!MyHiddenControl = "CustomerInactive"
End If
End Sub


AndrewEgan (AT) att (DOT) net (Andrew) wrote in message news:<be34760c.0310211324.1647c15b (AT) posting (DOT) google.com>...