Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF THEN ELSE with FORM CHECKBOX
I am pulling data from an Access database. The field is
a Yes/No (Checkbox). When I merge the records into Word, I know that I get a "True" or a "False" rather than a checked form checkbox or a non-checked form checkbox. So, I tried to do an IF ..THEN .. ELSE that if the field was true to insert a checked form checkbox and if the field is false to insert a non-checked form checkbox. Is this possible? How do I make the checkbox "code" correctly in this statement? Thanks. |
#2
|
|||
|
|||
Insert the check box merge field {Mergefield Fieldname} and see *exactly*
what it produces for a true result and enter that in place of True below. Use the required checkbox characters from (say) the Wingdings font where indicated then something along the lines of: {IF {Mergefield Fieldname} = True "Checked Box Character" "Unchecked box character"} will insert a checkbox or not according to the field - something similar is shown as an example at http://www.gmayor.com/Macrobutton.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jane wrote: I am pulling data from an Access database. The field is a Yes/No (Checkbox). When I merge the records into Word, I know that I get a "True" or a "False" rather than a checked form checkbox or a non-checked form checkbox. So, I tried to do an IF ..THEN .. ELSE that if the field was true to insert a checked form checkbox and if the field is false to insert a non-checked form checkbox. Is this possible? How do I make the checkbox "code" correctly in this statement? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
scanned in a form want to ad text to the form can not take off t. | Microsoft Word Help | |||
Search for Checkbox Form field in a macro | Microsoft Word Help | |||
Select only one checkbox from a list in a form | Microsoft Word Help | |||
Displaying Checkbox | Mailmerge |