Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format true/false mergefield
Hi,
I am creating a mail merge document using data stored in an access table. The access table contains a number of "yes/no" fields which have been formated to show either "Yes" or "No". When I insert these fields as mail merge fields in my word document, they display as "True" or "False". I have looked at the mergefied format options and can not find any obvious option to indicate whether to display the field as "true", "false", "yes" or "no". How can I get my mail merge document to display Yes/No rather than True/False? Or do I need to post this in the access newsgroup as I need to amend a field option in access and not a mail merge field in word? Thanks for any assistance. Gary O |
#2
|
|||
|
|||
The simplest solution is to use a conditional field as Word does not now
apply any formatting to the raw data: {IF {Mergefield fieldname} = "True" "Yes" "No"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Gary O wrote: Hi, I am creating a mail merge document using data stored in an access table. The access table contains a number of "yes/no" fields which have been formated to show either "Yes" or "No". When I insert these fields as mail merge fields in my word document, they display as "True" or "False". I have looked at the mergefied format options and can not find any obvious option to indicate whether to display the field as "true", "false", "yes" or "no". How can I get my mail merge document to display Yes/No rather than True/False? Or do I need to post this in the access newsgroup as I need to amend a field option in access and not a mail merge field in word? Thanks for any assistance. Gary O |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Word 2.0 format same as Word 2000 format? | Microsoft Word Help | |||
How do I do a conditional mail merge into a table | Mailmerge | |||
Math In Merge Field(s) | Mailmerge | |||
Mergefields change Format | Mailmerge | |||
Maintaining the format of linked tables. | Tables |