| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge formatting
I have an Access 2003 database where some of the number fields are in
scientific format. In Word 2003 when I insert the scientific formatted fields, they appear in decimal format. How can I get Word to duplicate the scientific format of the original Access field? |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail merge formatting
|
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail merge formatting
Thanks for the reply Robert.
I can't find a MERGEFIELD scientific notation switch. Your suggestion of converting the number to text sounds in Access good; but I think Access will probably take a number like 1.1E2 and convert it to 110. I am dealing with very small numbers, such as 5.1E-9 and I think the text conversion will be 0.00000000051. At any rate I'll give it a try and let you know. On Feb 24, 12:38 pm, "Robert M. Franz (RMF)" wrote: Hello sbarker wrote: I have an Access 2003 database where some of the number fields are in scientific format. In Word 2003 when I insert the scientific formatted fields, they appear in decimal format. How can I get Word to duplicate the scientific format of the original Access field? the standard (short) answer to questions like this is: change the connection method, or add formatting switches to the MERGEFIELDs in Word. In your specific situation, I'm not sure there really _are_ formatting switches. You might have to resort to add a field to access which converts the number to text, and bring that information into Word. HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail merge formatting
Hi sbarker,
If you code your mergefield as: {QUOTE {SET z{MERGEFIELD dbValue}} {SET a{=ABS(z)}} {SET b{=9-(a10^9)-(a10^8)-(a10^7)-(a10^6)-(a10^5)-(a10^4)-(a10^3)-(a10^2)-(a10^1)-(a10^0)-(a10^-1)-(a10^-2)-(a10^-3)-(a10^-4)-(a10^-5)-(a10^-6)-(a10^-7)-(a10^-8)} {SET c{=int(a/10^b)+mod(a,10^b)/10^b} {c \# 0.00}E{b \# +00;-00}} where 'dbValue' is your mergefield's name, any numbers between 10^-9 and 10^9 will be expressed in scientific notation. You can increase the number of expressions in either direction if need be. Note: the field braces (ie ' { }') are all created in pairs via Ctrl-F9 - you can't just type them in. Cheers -- macropod [MVP - Microsoft Word] ------------------------- wrote in message ups.com... Thanks for the reply Robert. I can't find a MERGEFIELD scientific notation switch. Your suggestion of converting the number to text sounds in Access good; but I think Access will probably take a number like 1.1E2 and convert it to 110. I am dealing with very small numbers, such as 5.1E-9 and I think the text conversion will be 0.00000000051. At any rate I'll give it a try and let you know. On Feb 24, 12:38 pm, "Robert M. Franz (RMF)" wrote: Hello sbarker wrote: I have an Access 2003 database where some of the number fields are in scientific format. In Word 2003 when I insert the scientific formatted fields, they appear in decimal format. How can I get Word to duplicate the scientific format of the original Access field? the standard (short) answer to questions like this is: change the connection method, or add formatting switches to the MERGEFIELDs in Word. In your specific situation, I'm not sure there really _are_ formatting switches. You might have to resort to add a field to access which converts the number to text, and bring that information into Word. HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail merge formatting
Hi sbarker,
The core of the formula field referred to in my previous post is included in my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 Cheers -- macropod [MVP - Microsoft Word] ------------------------- wrote in message ups.com... Thanks for the reply Robert. I can't find a MERGEFIELD scientific notation switch. Your suggestion of converting the number to text sounds in Access good; but I think Access will probably take a number like 1.1E2 and convert it to 110. I am dealing with very small numbers, such as 5.1E-9 and I think the text conversion will be 0.00000000051. At any rate I'll give it a try and let you know. On Feb 24, 12:38 pm, "Robert M. Franz (RMF)" wrote: Hello sbarker wrote: I have an Access 2003 database where some of the number fields are in scientific format. In Word 2003 when I insert the scientific formatted fields, they appear in decimal format. How can I get Word to duplicate the scientific format of the original Access field? the standard (short) answer to questions like this is: change the connection method, or add formatting switches to the MERGEFIELDs in Word. In your specific situation, I'm not sure there really _are_ formatting switches. You might have to resort to add a field to access which converts the number to text, and bring that information into Word. HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting in Mail Merge | Mailmerge | |||
| Mail Merge Formatting | Mailmerge | |||
| Mail Merge fields merge with different formatting | Microsoft Word Help | |||
| Zip+4 formatting in mail merge | Mailmerge | |||
| mail merge formatting | Mailmerge | |||
Linear Mode
