I believe you could avoid the problem if:
1. copy table to txt delim with tab, and then
2. insert the txt file into word
>I would appreciate some insight...
>I have inserted a database into a word doc, which is working fine. It is 4 columns (3 text and 1 amount field). Problem is, the amount field will not display cents when there are zero's and it drops the decimal also. Any ideas?
>
>.property number. .description. . cost . .serial number.
> 112131 438.
> 112132 438 3
> 112133 438.03
>
>
>This is what displays, the first record should be 438.00 and the 2nd 438.30. It is displayed based on selections in the "insert database wizard", which has no cell format options. This is the syntax for that insert. I used the periods to format the width of each cell because I could not figure out another way other than building the whole page in script, which we do not want to do because we have no one else that has the knowledge to maintain it if it broke or needed modified.
>
>{DATABASE \d "R:\\Finacct\\TestPropNum\\memodata.dbf" \c "DSN=FoxPro Files -
>Word;UID=;PWD=;SourceDB=R:\\Finacct\\TestPropNum\;SourceType=DBF;
>Exclusive=No;BackgroundFetch=No;Collate=MACHINE;Null=Yes;Deleted=Yes;" ;
>\s "SELECT nproperty as '. Property Number .', descrip as ;
>'. Description .', ;
>acqcost as '. Cost .', serialno as '. Serial Number .' ;
>FROM memodata.dbf ORDER BY `nproperty`" \l "2" \b "63" \h}
>
>
>Thanks, Chuck