Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1114
  • Last Modified:

IIF checkbox isnull(?) issue

I have a query with a stack of these for different fields on my "picker" form:

Like Iif(IsNull([Forms]![frmJoblisttemp]![JobDescription]),"*","*" & [Forms]![frmJoblisttemp]![JobDescription] & "*")

They work very well by filtering if there is data in the "picker" field but I cant seam to work out how to achieve the same result with checkbox because a check box can't be null only true or false, there is no "ignore me and include both data types" option.

Can someone help me out please.
0
rexwithers
Asked:
rexwithers
1 Solution
 
Wayne Taylor (webtubbs)Commented:
So instead of Null, do you want to check for False?

    Like Iif([Forms]![frmJoblisttemp]![JobDescription],"*" & [Forms]![frmJoblisttemp]![JobDescription] & "*","*")

Regards,

Wayne
0
 
tonydemarcoCommented:
try:

Expr1: IIf([Forms].[Form1].[Check30]=Yes,"The Box is Checked","The Box Is Not Checked")
0
 
flavoCommented:
>because a check box can't be null only true or false,
Sure they can - just not by default.  Set the Checkboxes "Tri-state" property to Yes.  You may need to do something else (ie something with conditional formatting on another control)to emphasise the difference between Null and False.

Dave
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
rexwithersAuthor Commented:
OK, great idea... so if a triple state checkbox control is grey (the triple state) its value reports as null?
0
 
flavoCommented:
Yup, that's correct.
0
 
rexwithersAuthor Commented:
Thanks heaps everyone
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now