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

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

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

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