melanie
A Walking Contradiction
- Local time
- Today, 19:41
- Joined
- Jun 6, 2003
- Messages
- 101
Here I am limping and whimpering back to the forum for help..again...
I am mail merging to Word. Some of my table columns are Yes/No data
types. I would like them to come out as check boxes in Word but they
merge as True and False.
Please, how do I overcome this latest dilemma?
Is this simple or am I missing something?
I found the following snippet while trawling the web looking for the answer:
Display database Yes/No information as Yes/No
Display any Yes/No information as a checkbox
Most database sources store Yes/No information as 0 (=No) and -1 (or 1; = Yes) - and this is how Word will display the contents of a Yes/No type of mergefield in a merge. You can display anything you want by using an IF field.
Example:
{ IF { Mergefield YesNo } = "0" "No" "Yes" }
Display: Yes
Word 2002 will occasionally pass Access 2002 database Yes/No results as the literal text "Yes" and "No". Watch out for this if you're convering mail merges from earlier versions.
If you'd prefer to display an unchecked or checked checkbox you can insert the corresponding symbols in the IF field instead of the "No" and "Yes" in the example.
What exactly does the last paragraph pertain to...what are the "corresponding symbols"? I can get the fields to display yes displaying the above code, but I haven't achieved the checkbox ticked status yet, inspite of trying desperately.
Hoping someone with an infinite amount of patience can spell this out to me, slowly, very very slowly.
From the frustrated chick hammering on the keyboard
Melanie
I am mail merging to Word. Some of my table columns are Yes/No data
types. I would like them to come out as check boxes in Word but they
merge as True and False.
Please, how do I overcome this latest dilemma?
Is this simple or am I missing something?
I found the following snippet while trawling the web looking for the answer:
Display database Yes/No information as Yes/No
Display any Yes/No information as a checkbox
Most database sources store Yes/No information as 0 (=No) and -1 (or 1; = Yes) - and this is how Word will display the contents of a Yes/No type of mergefield in a merge. You can display anything you want by using an IF field.
Example:
{ IF { Mergefield YesNo } = "0" "No" "Yes" }
Display: Yes
Word 2002 will occasionally pass Access 2002 database Yes/No results as the literal text "Yes" and "No". Watch out for this if you're convering mail merges from earlier versions.
If you'd prefer to display an unchecked or checked checkbox you can insert the corresponding symbols in the IF field instead of the "No" and "Yes" in the example.
What exactly does the last paragraph pertain to...what are the "corresponding symbols"? I can get the fields to display yes displaying the above code, but I haven't achieved the checkbox ticked status yet, inspite of trying desperately.
Hoping someone with an infinite amount of patience can spell this out to me, slowly, very very slowly.
From the frustrated chick hammering on the keyboard
Melanie