How do I modify database results page to show checkboxes?

[Guest]

Instead of showing the contents of the yes/no fields of my database as
textboxes containing the word True or False I would like to display checked
checkboxes if the field contains the word True, blank checkboxes if the field
contains the word "false"

I thought the code below would work but it doesn't


<% if FP_FieldHTML(fp_rs,"breakroom") ="True" then

response.write("VALUE=ON>")
end if%>

 

[Thomas A. Rowe]

Try:

<input type="checkbox" name="breakroom" value="ON" <% If fp_rs("breakroom") = True Then
Response.Write "Checked"%>> Yes

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================