p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Check Boxes vs Yes/No, etc


Message #1 by PStreeter@C... on Fri, 21 Jun 2002 11:53:54 CST
When I define a field as Yes/No in a table, then select the 
field for a form or report, it defaults to  a check box, but 
when I use "xxx:Iif(Condition.Yes,No)" in a query, it 
defaults to the raw -1 and 0 and i can only overide this 
to get "True/False," "Yes/,No," or "On/Off" in a report. 
How can I get check boxes? Somehow it seems like a 
situation for rolling on the floor, kicking and screaming, 
but I doubt that that would work. Does anyone know how 
to get check boxes? Have I missed something really easy 
and obvious? (It wouldn't be the first time.) I assume that 
making the query into a make table query might work, but 
is there any way on a select query.

Paul


Message #2 by ProDev <prodevmg@y...> on Fri, 21 Jun 2002 13:28:13 -0700 (PDT)
--0-988530078-1024691293=:65068
Content-Type: text/plain; charset=us-ascii


If your table is set to a check box in the properties window of the field in question, the query should default to a check box. If
for some reason, your field in your query or report/form is not, then go to the properties window for the field in the query or the
text box of the report/form you should be able to determine the appearance.
 
Hope that helps.
 
 
  PStreeter@C... wrote: When I define a field as Yes/No in a table, then select the 
field for a form or report, it defaults to a check box, but 
when I use "xxx:Iif(Condition.Yes,No)" in a query, it 
defaults to the raw -1 and 0 and i can only overide this 
to get "True/False," "Yes/,No," or "On/Off" in a report. 
How can I get check boxes? Somehow it seems like a 
situation for rolling on the floor, kicking and screaming, 
but I doubt that that would work. Does anyone know how 
to get check boxes? Have I missed something really easy 
and obvious? (It wouldn't be the first time.) I assume that 
making the query into a make table query might work, but 
is there any way on a select query.

Paul




Lonnie Johnson 
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV 




---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup
Message #3 by PStreeter@C... on Fri, 21 Jun 2002 15:54:35 CST
On Fri, 21 Jun 2002 13:28:13 -0700 (PDT) ProDev wrote:

> 
> If your table is set to a check box in the properties window of the
> field in question, the query should default to a check box. ....

Indeed it does. The problem is when the column of the query is 
"name:IIF(condition,yes,no)". Access makes the field in the query 
result a number with -1 for yes and 0 for no. When I made it a 
make table query, the fields were defined as numbers in the table. 
I changed them all to Yes/No and changed the query to append, 
and paired it with a delete query. The final result is the report that 
I wanted. It's a case where he graphic representation of check 
boxes seemed the most easily understood.

Thanks

Paul


Message #4 by "Amy Wyatt" <amyw@c...> on Mon, 24 Jun 2002 14:14:48
I guess I do not understand you problem completely. What is preventing you 
from creating the Checkbox control and binding it to the query field? I 
know it will not do it automatically (if you drag and drop the field on 
the report) because Access does not recognize the field as a boolean 
beyond defining it explicitly as such in a table but it does not prevent 
you from binding it to a checkbox if you are returning a boolean value 
(true/false, yes/no, 0,-1). How exactly is it failing and when?

Amy

> When I define a field as Yes/No in a table, then select the 
field for a form or report, it defaults to  a check box, but 
when I use "xxx:Iif(Condition.Yes,No)" in a query, it 
defaults to the raw -1 and 0 and i can only overide this 
to get "True/False," "Yes/,No," or "On/Off" in a report. 
How can I get check boxes? Somehow it seems like a 
situation for rolling on the floor, kicking and screaming, 
but I doubt that that would work. Does anyone know how 
to get check boxes? Have I missed something really easy 
and obvious? (It wouldn't be the first time.) I assume that 
making the query into a make table query might work, but 
is there any way on a select query.

Paul



  Return to Index