How to write to an Access table with Yes/No Fields

Results 1 to 2 of 2

Thread: How to write to an Access table with Yes/No Fields

  1. #1
    Wes Hegge Guest

    Default How to write to an Access table with Yes/No Fields

    I have an Access table that has a Yes/No field. My web page form has a <select> pull down box with the oprions of Yes and No. How do I write this variable to the table? I keep gettig a type mismatch error.

  2. #2
    Join Date
    Dec 1969
    Posts
    38

    Default RE: How to write to an Access table with Yes/No Fi

    When writing to the database, use True or False. For example :<BR><BR>.....<BR>recordset.addnew<BR>if request.form("pull_down_box") = "yes" then<BR> recordset("field_name") = true<BR>else<BR> recordset("field_name") = false<BR>end if<BR>recordset.update<BR><BR>Hope this helps!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •