View Single Post
  #3   Report Post  
weigoldk
 
Posts: n/a
Default Single and Double Quotes in Data Merge Incorrectly in Word 200

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" wrote:

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" wrote in message
...
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"?