Scientific notation format of an Access mail merge field into Word

[sbarker]

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 handle this formatting problem?

 

[John W. Vinson]

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 handle this formatting problem?

The numbers AREN'T formatted. Numbers are just numbers - 32- or 64-bit
binary representations in a defined floating point arrangement. The
formatting is applied prior to display.

If you want to display the numbers in some particular format in Word,
use the Format() function to explicetly convert the number to a text
string: e.g.

ShowNum: Format([fieldname], "0.0000E-"

to show the number in the form 3.1415E0 for 3.1415, or 3.1415E-2 for
0.0031415. It takes some digging in the online help to get this!
Select the Format property of a table field or form control and hit
F1, and display the number format option.

John W. Vinson [MVP]