WD: A Field Calculation Error Occurred in Record . . .

SYMPTOMS

Word for Windows

The error message "A field calculation error occurred in record #" (where # is every record number) may appear when you use an IF field to include files whose names are specified in other merge fields, and any of the merge fields specified is blank.

The following is a sample statement that will exhibit this problem

{IF {MERGEFIELD contribution} > 1000 {INCLUDETEXT {MERGEFIELD thanks}}
   {INCLUDETEXT {MERGEFIELD give_more}} }
				

where "thanks" and "give_more" are fields in the data document that contain names of files to be included, and either of the fields is blank.

Word for the Macintosh

In Word 6.0 for the Macintosh, when using an INCLUDETEXT field to include a document, if the path is not enclosed by quotation marks, the error message "A field calculation error occurred in record #" will appear. The following is an example that will give the error:

{IF {MERGEFIELD No} > 1 "{INCLUDETEXT Mac HD:Desktop Folder:Doc 1}
   "{INCLUDETEXT Mac HD:Desktop Folder:Doc 2}" }
				

Also, if there are any extra spaces in the path statement, the same error will appear. In the example above, if there is a space inserted after either ":" (colon), the error will appear, regardless of whether the quotation marks are used.