DB results field says "True", needs to be "Yes".

[johnruthroff]

My insert record form (MS Access DB) has several checkboxes. In Access these fields are set up as "Yes/No" data type. For whatever reason, when the results come on on a web based form the text that comes out is "True/False" and not "Yes/No" (using a checkbox for the results would be the simple solution but isn't what the end-user wants, they want text and they want it to say "Yes" and "No", not "True" and "False".

How can I do this?

Thanks,

John

[Newsgroup_User]

Assuming you are using ASP just write an IF statement like this

<%
if recordset.field.item("field").value = True then
response.write("Yes")
else
response.write("No")
End if
%>

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"johnruthroff" <webforumsuser@macromedia.com> wrote in message
news:e2gdlv$ift$1@forums.macromedia.com...
> My insert record form (MS Access DB) has several checkboxes. In Access
> these
> fields are set up as "Yes/No" data type. For whatever reason, when the
> results
> come on on a web based form the text that comes out is "True/False" and
> not
> "Yes/No" (using a checkbox for the results would be the simple solution
> but
> isn't what the end-user wants, they want text and they want it to say
> "Yes" and
> "No", not "True" and "False".
>
> How can I do this?
>
> Thanks,
>
> John
>