Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

checkBox in mailMerge form letter

Status
Not open for further replies.

alvintse

Programmer
Aug 1, 2003
66
US
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?

Thanks
 
Thanks Phaed. I am new with Microsoft Office, could you pleasse to show me how?

Thanks
 
first of all, u must not be vague (although, no criticism meant):

on the field value from the data?

is vague, don't u think?

"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.

Damn, i starting 2 write like fumei
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top