Mail merge from Access - Yes/No field converts to True/False

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Guerry - 08 May 2005 20:39 GMT

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

Reply to this Message

Peter Jamieson - 08 May 2005 23:57 GMT

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

>I understand that Word2003 does not retain formatting from the source
> recordset when retrieving data from Access. I am retrieving data from a
[quoted text clipped - 7 lines]
>
> Joe Guerry

Reply to this Message

J Guerry - 09 May 2005 04:02 GMT

Thanks for the quick answer. Both approaches work well.

Joe Guerry

> 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.
[quoted text clipped - 15 lines]
> >
> > Joe Guerry

Reply to this Message