I'm having a problem where the date that a document is merged is being inserted into the date field of the word document when it is void of data in the Access source table.

The Code for the field is:

{ MERGEFIELD Report_Date \@ "dd/MM/yyyy" }


This puts date in the format I want BUT the dates which are blank are given today's date

I'd be very grateful if anyone knows how I can fix it.