Data type mismatch in criteria expression error when using a DetailsView control in VWD2005 on access DB

I have a Yes/No field in an Access 2000 db that im using to show a simple yes/no checkbox on a web form in VWD2005.

When I click the insert link, Im getting the error "Data type mismatch in criteria expression".

I believe this is because the form is giving ADO.NET true/false instead of yes or no. Is this correct? And how do I make it so Access will accept the input from a checkbox in a detailsview control?



8/7/2005 10:24:57 AM 72751 articles. 3 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 18

Yes you are correct. The check box checked is a boolean value that is 1 if true and 0 if false.

You can hardcode the yes/no in the insert command just put a condition for if the the checkbox.checked = 1

- SH

8/7/2005 11:09:36 AM