Single and Double Quotes in Data Merge Incorrectly in Word 2003

[weigoldk]

I am merging an Access query with a Word Main document.

All fields come in correctly except one that is a measurement.

The filed in Access, for example is, 6'02" but when the merge is complete,
it shows up in Word as 602 and it is underlined.

Does anyone know how to show it as 6'02"?

 

[Doug Robbins - Word MVP]

What type of field is it in Access. With a Text field containing data such
as that, I cannot reproduce your problem when using Office 2003.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[weigoldk]

Thanks for responding.

The field is of type text. It has an input mask that includes the ' and ".

Originally, I saved the symbols with the field so that the contents were
6'02" or 5'11". I decided to go back into Access and look for a solution
there. I changed the input mask so that it did NOT save the symbols with the
data. I then added two formula fields to my query. I split the field into
left and right--left[height],1 and right[height],2. Back in Word, I used my
two new fields and put the ' and " in OUTSIDE of my field names.

 

[Doug Robbins - Word MVP]

The input mask would only control how the data is displayed in Access, not
how it is stored. Mailmerge will only access the data in it's stored form.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Thanks for responding.

The field is of type text. It has an input mask that includes the ' and ".

Originally, I saved the symbols with the field so that the contents were
6'02" or 5'11". I decided to go back into Access and look for a solution
there. I changed the input mask so that it did NOT save the symbols with
the
data. I then added two formula fields to my query. I split the field
into
left and right--left[height],1 and right[height],2. Back in Word, I used
my
two new fields and put the ' and " in OUTSIDE of my field names.

What type of field is it in Access. With a Text field containing data
such
as that, I cannot reproduce your problem when using Office 2003.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP