 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2005Single 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"? 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.  SignatureHope 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 >I am merging an Access query with a Word Main document. > [quoted text clipped - 4 lines] > > 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. > 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. [quoted text clipped - 7 lines] > > > > 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. SignatureHope 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. > [quoted text clipped - 23 lines] >> > >> > Does anyone know how to show it as 6'02"? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.