Hi,

I would like to reduce the following code:

Code:
    If chkPrivate = 1 Then
        ValuePrivate = "on"
    Else
        ValuePrivate = "off"
    End If
I know it's not a lot of code to begin with but I have a whole bunch of these
to put into my program so it does add up and it's time consuming to maintain.

Basically, what I'm trying to do is to convert the check box values of 1 and 0 to
"on" or "off", respectively.

Any ideas would be greatly appreciated..

Dan