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.

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

"Victor Lazlo" wrote in message
news
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.

[Frank]

On and off have been seeking an answer to this very same problem for a couple
of years. Obviously been looking in the wrong place!!

Mail merge now works brilliantly - thanks for raising the issue and for the
(so simple) solution.
--
Frank


"Peter Jamieson" wrote:

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

"Victor Lazlo" wrote in message
news
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.