Reply
 
Thread Tools Display Modes
  #1   Report Post  
weigoldk
 
Posts: n/a
Default Single and Double Quotes in Data Merge Incorrectly in Word 2003

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"?
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default Single and Double Quotes in Data Merge Incorrectly in Word 2003

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"?



  #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"?




  #4   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default Single and Double Quotes in Data Merge Incorrectly in Word 200

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

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






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
My double click is not working in Word 2003, help? Suzanne Microsoft Word Help 2 October 21st 05 04:21 AM
Add checkboxes with macro in Merge document? Bryan L Tables 3 October 19th 05 04:05 PM
How can I reformat an HTML doc in Word from double to single spaced? Bawcom Microsoft Word Help 3 July 16th 05 12:33 AM
Help to merge Image (Doug Robins?) JohnB Mailmerge 21 June 23rd 05 05:28 PM
mail merge 2 x 2 double sided brad572 Mailmerge 3 April 4th 05 09:18 PM


All times are GMT +1. The time now is 07:34 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"