I have a database tracking new employee information. I use a query to pull out new employee and their specific application needs(the application needs are check boxs). When I merge the two all of the check boxes on the merge document come in checked off. The query has only the applications I selected checked off. In Word 97 I was able to complete the steps below to create a check box however it's not working in 2002. Has the coding changed from below?
Any suggestions?
1. Open the main document for the mail merge and
place insertion point where you want the checkbox
to appear.
2. On the Mail Merge toolbar, click the drop-down
Insert Word Field button. Choose "If…Then…Else"
3. Under If, in the Field Name list, click to select
the field name that is the check box column in
Access (i.e. GW.)
4. In the Comparison list, click to select "Equal To."
5. In the Compare To box, type 0 (zero).
6. In the Insert This Text box, hold down the ALT key
and on the numeric keypad, type 0168 (make sure
numlock is on.)
7. The ¨ image appears. Select it and press CTRL + D
8. The font dialog box appears. Choose Wingdings and
then click OK. You should now see an empty check
box.
9. Under Otherwise Insert this Text, press ALT and
type 0254.
10. The þ image appears. Select it and press CTRL + D
11. The font dialog box appears. Choose Wingdings and
then click OK. You should now see a checked check
box. Click OK. Save your document.
Thanks so much in advance for any solutions given.
JJCPAC
Any suggestions?
1. Open the main document for the mail merge and
place insertion point where you want the checkbox
to appear.
2. On the Mail Merge toolbar, click the drop-down
Insert Word Field button. Choose "If…Then…Else"
3. Under If, in the Field Name list, click to select
the field name that is the check box column in
Access (i.e. GW.)
4. In the Comparison list, click to select "Equal To."
5. In the Compare To box, type 0 (zero).
6. In the Insert This Text box, hold down the ALT key
and on the numeric keypad, type 0168 (make sure
numlock is on.)
7. The ¨ image appears. Select it and press CTRL + D
8. The font dialog box appears. Choose Wingdings and
then click OK. You should now see an empty check
box.
9. Under Otherwise Insert this Text, press ALT and
type 0254.
10. The þ image appears. Select it and press CTRL + D
11. The font dialog box appears. Choose Wingdings and
then click OK. You should now see a checked check
box. Click OK. Save your document.
Thanks so much in advance for any solutions given.
JJCPAC