If "Yes" in check how do I show value and if "No" no value

W

Wayne Viles

I have a check box with combo "Yes" or "No". I have created a calculated
field that shows a value and would like that value to be displayed if the
check box selection is "Yes" and to show a 0 or blank value if "No" is
selected. Can I simply add something in the Record Source of the calculated
field, eg. =([City and County] = "Yes") then follow on with the calculated
field?
 
K

Ken Snell

For the control that you currently have bound to the calculated field,
change its Control Source property to this:

=IIf([NameOfCheckBox] = -1, [NameOfCalculatedField], Null)
 

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

yes/no for old data 4
Access how do you set a yes/no data type as required? 0
Select Case for "Yes/No" box 2
Enter Parameter Value in Access Form 0
update yes / no field in table based on another table 3
Calculating averages on a form 3
Yes/No combo box 5
Null value in Yes/No field 2

Top