If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail merge from Access - Yes/No field converts to True/False
I understand that Word2003 does not retain formatting from the source
recordset when retrieving data from Access. I am retrieving data from a field that is formatted as Yes/No in Access, however it displays as True/False in the Word document. I can not find a formatting function in word that will allow me to force this to format as Yes/No. Any advice would be appreciated. Thanks, Joe Guerry |
#2
|
|||
|
|||
You can either use a Query in Access with a function to return "Yes" or "No"
or use a nested IF field in Word, e.g. { IF { MERGEFIELD myyesnofield } = "True" "Yes" "No" } where both sets of {} are inserted using ctrl-F9 Peter Jamieson "J Guerry" wrote in message ... I understand that Word2003 does not retain formatting from the source recordset when retrieving data from Access. I am retrieving data from a field that is formatted as Yes/No in Access, however it displays as True/False in the Word document. I can not find a formatting function in word that will allow me to force this to format as Yes/No. Any advice would be appreciated. Thanks, Joe Guerry |
#3
|
|||
|
|||
Thanks for the quick answer. Both approaches work well.
Joe Guerry "Peter Jamieson" wrote in message ... You can either use a Query in Access with a function to return "Yes" or "No" or use a nested IF field in Word, e.g. { IF { MERGEFIELD myyesnofield } = "True" "Yes" "No" } where both sets of {} are inserted using ctrl-F9 Peter Jamieson "J Guerry" wrote in message ... I understand that Word2003 does not retain formatting from the source recordset when retrieving data from Access. I am retrieving data from a field that is formatted as Yes/No in Access, however it displays as True/False in the Word document. I can not find a formatting function in word that will allow me to force this to format as Yes/No. Any advice would be appreciated. Thanks, Joe Guerry |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 Auto Mail Merge TO Word 2003 | Mark D Ski | General Discussion | 0 | March 11th, 2005 04:49 AM |
selecting categories field in mail merge | Axe | General Discussion | 1 | February 8th, 2005 01:04 AM |
Extra Access Instance with Automated Mail Merge | Neil Ginsberg | General Discussion | 9 | January 20th, 2005 02:41 AM |
Repositioning columns of a data source field within the "Edit Recipient List" dialog box within the Mail Merge wizard | Dave | Mailmerge | 1 | November 10th, 2004 06:29 PM |
Mail merge to Word from Access 2000 | Anthony | General Discussion | 1 | August 4th, 2004 12:35 PM |