This topic is locked

checkbox mask value of 1/0 to yes/no

12/14/2006 2:00:13 PM
ASPRunnerPro General questions
S
SteveL author

Hi I am sending this email out, but all the fields where I have a check box the values print as 1 and 0. Is there a way I can send a email of these fields with the values of yes and no instead? I know a work around is using the radio buttons. But i ilke the check boxes <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4209&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

Thanks

J
Jane 12/15/2006

Steve,
you can use following code in your event:

Dim keys

message =""
keys = dict.keys

For n = 0 To dict.Count-1

if (keys(n)="FieldName1" or keys(n)="FieldName2") and dict(keys(n))=1 then

message = message & keys(n) & " : " & "Yes" & vbcrlf

else

if (keys(n)="FieldName1" or keys(n)="FieldName2") and dict(keys(n))=0 then

message = message & keys(n) & " : " & "Yes" & vbcrlf

else

message = message & keys(n) & " : " & dict(keys(n)) & vbcrlf

end if

end if

Next



where FieldName1 and FieldName2 are your actual field names.