Word 2002 MailMerge & Access 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Victor Lazlo - 02 May 2006 19:11 GMT

My null value merge field displays 12:00:00 AM in a word merge document.
Where is there an option to "Suppress Null Value" when the Access Query
merged field is null.

Reply to this Message

Peter Jamieson - 03 May 2006 08:12 GMT

There isn't an option to do that in Word.

You can try using the following nested field:
{ IF "{ MERGEFIELD mydate }" = "12:00:00 AM" "" "{ MERGEFIELD mydate }" }

All the {} have to be the special field braces you can insert using ctrl-F9.

If that doesn't work, you can try switching the way Word connects to
theAccess data to DDE by checking Word Tools|Options|General|"Confirm
conversion at open", going through the connection process again, and
selecting the DDE option when offered.

Peter Jamieson

> My null value merge field displays 12:00:00 AM in a word merge document.
> Where is there an option to "Suppress Null Value" when the Access Query
> merged field is null.

Reply to this Message