By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

checkbox yes/no

P: n/a
The scope of a boolean query displays -1 or 0.
You can modoficare to show a checkbox?
Dec 21 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If this yes/no field comes from a table, you can open the table in design
view, select the yes/no field, and in the lower pane (on the lookup tab),
set the Display Control property to Check Box. The query will then display
the field as a check box.

If that is not practical (e.g. if it is a calculated expression, or if you
can't modify the back end), you cannot do that through the interface. You
can do it programmatically like this:
Call
SetPropertyDAO(Currentdb.QueryDefs("Query1").Field s("Expr1"),"DisplayControl",
dbInteger, 106)
where the SetPropoertyDAO() function is shown at the foot of this page:
http://allenbrowne.com/AppPrintMgtCo...SetPropertyDAO

Of course, it would be dead easy to use a form (in datasheet view if you
want it to look like a query) or report, with a check box for this field.
Queries are for getting data, not really designed to give you fine control
over the interface.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ni*************@libero.itwrote in message
news:12**********************************@e4g2000h sg.googlegroups.com...
The scope of a boolean query displays -1 or 0.
You can modoficare to show a checkbox?
Dec 21 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.