Help! Making CheckBox report different value

[Karen]

I have a page with 5 checkboxes.

The checkboxes have the values:
"Purchase"
"Cash-Out No Refi"
etc...

If someone checks the box for "Purchase", I need it to report the value "Y" ina string of text.

I'm creating a .TXT file that uploads into a Calyx database with comma delimited values. The value that returns a check to the proper box in Calyx is "Y". I know how to make either the word "Purchase" appear, or a "True" value, but not "Y".

Please help!

Thanks.

~Steph

[Karen]

I figured it out...at least one way to do it. For anyone who might be interested, here's what I'm doing.


Dim PurchAns As String
If cbPurchase.Checked Then
PurchAns = "Y"
Else
PurchAns = "N"
End If



Then, I'm just referring to "PurchAns" in my string of text. Thanks to everyone who looked at my post!

~Steph