I am using MS Access XP to generate data to merge into a MS Word XP template. The data source is a query that extracts data from some tables as well as fields on forms (while the form is open). In the query, I refer the fields on the form as [forms]![myForm]![PersonName], etc. These fields sometimes merge sometimes they don't. When I use the Format$ function (i.e. Format$[forms]![myForm]![PersonName]), it seems to have worked for the text fields. There are some date fields as well and I don't know whether or not the Format function will work for the date field.
There are some 200+ queries that I need to amend. I am wondering if any body knows the cause of this problem and an easy fix for it.
Note: This problem did not occur in Access/Word 97.