Access to Word

[Brenda]

I have a query in Access that has blank dates and when it
is merged to Word the blanks are merged as 12:00 AM. I am
not sure why or how to fix this problem.

 

[Peter Jamieson]

It is usually a result of the way Word gets its data from Access. Possible
workarounds include:
a. use a nested IF field in Word to deal with whatever result you see (is
it 12:00 AM or 12:00:00 AM?) when you insert the field. e.g.
{ IF "{ MERGEFIELD mydate }" = "12:00 AM" "" "{ MERGEFIELD mydate }" }
where all the {} are special field braces you can insert using ctrl-F9
b. connect to Access using a different method. Check Word
Tools|Options|General|"confirm conversions at open", go through the
connection process again, and try either DDE or ODBC when prompted.