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

Newbie Help - IF Yes No Function 0
Split form 0
Drop down list control value in vba 2
Dynamic Naming of Form Button 3
Filtering and summing a calculated field on a subform 0
yes/no for old data 4
Select Case for "Yes/No" box 2
Page numbering with Merged Document and IF statements 1

Top