I have created form with microsoft Word 2002 SP3 for mail merge with the data from Access. There is a checkbox in the letter.
Is it possible for me to program the status of the checkbox based on the field value from the data?
"the field"......cool, so the answer is yes. since there is only one field, simply check the value of THE field, and if it is X, make the chekcbox.value = true (i.e checked). If THE field is Y, make checkbox.value = false (i,e not checked). simple.
However, I uspect it is a bit more complicated than that. I also assume there is at least the possibility there may be more than one field, and indeed there may be need for some logic to determine if the checkbox needs to be checked, or not.
But as you posted..."the field"...the answer was, and still is....yes.
perhaps more details?
if it helps, the syntax for setting the chekcbox (assuming the chekcbox name is "CheckboxResponse" - but could be anything) is something like:
If field condition = whatever Then
CheckboxResponse.Value = True
Else
CheckbocResponse.Value = False
End if.
There are other ways, but still all will test the condition of field data, and set the checkboc valuer accordingly.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.