What is the syntax to filter on a check box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am somewhat rusty and getting back into reporting in Access. I am trying to
filter on a check box and find that it does not respond to a filter on yes or
no. Can anyone help by telling my how to write the syntax for filtering a
report on the check box. I am just double clicking on the header on the
report in design view and building an expression manually. Would be very
grateful for some help!
 
You can use the constants vbYes or vbNo, or you can use -1 for true, 0 for
false
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syntax problem for text criteria to filter a report 8
syntax to filter a report on a check box 1
Filter Syntax error? 1
filtering data on report by date? 2
syntax error 1
Report filters by checked box 4
Multiple report filter using combo box on form 2
combo box filter 1

Back
Top