Re: Table cell display differences between 97 and XP
From: Graham Mayor (gmayor_at_NOSPAMmvps.org)
Date: 04/19/04
- Next message: Bob Z.: "Re: MergeField Limits in tables?"
- Previous message: JW: "Table cell display differences between 97 and XP"
- In reply to: JW: "Table cell display differences between 97 and XP"
- Next in thread: JW: "Re: Table cell display differences between 97 and XP"
- Reply: JW: "Re: Table cell display differences between 97 and XP"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Apr 2004 16:41:13 +0100
Microsoft has changed the method used to connect to data and Word is not
required to provide the formatting. This is easily done with a switch - see
http://www.gmayor.com/formatting_word_fields.htm. If you want to revert to
the older connection method, this too is possible - see the Excel data
section (for which purpose Excel and Access have the same issues) of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
JW wrote:
> I've alreadsy posted this to the Access group, but am now
> wondering if it is a Word XP problem.
>
> the long explanation is below, but to summarise:
>
> An existing 97 Access database has been upgraded to XP.
> The database has a number of queries relating to money and
> these are merged as invoices, daily reports etc..
>
> However, after the conversion (upgrdae?!) one of the
> fields from the access queries to calculate VAT will not
> display in Word in the correct format ie £11.17 it prints
> out as 11.1702127659574
>
> Does anyone know of any differences in Word XP and 97 that
> might explain this?
>
> JW
>
>
> Longer explanation to Access group:
>
> A 97 access database which has a number of queries to show
> how much of various amounts are VAT eg "Rate VAT: [Total
> Rate]*17.5/117.5" worked perfectly well in Access 97 and
> the results were merged to various Word documents as
> invoices, daily reports etc. in the correct format and
> decimal places eg £11.17
>
> After upgrading the calculations still appear to be
> working in the queries as the resulting tables correctly
> display amounts as above ie £11.17
>
> However, when these are now merged to Word XP they will
> only display as 11.1702127659574 (!?)
>
> If you ROUND the calculation in the query the resulting
> table still displays accurately £11.17 but the resulting
> merged document will only display as 11.17 ie without the
> currency symbol (!!??)
>
> Obviously it is possible in the Word document to add a £
> symbol but ... this is going to be a lot of additional
> work, ie all the existing queries with this calculation
> will have to be ROUNDed and then all the existing merge
> documents will have to have the new field names added and
> the £ sysmbol added.
>
> Why is the happening?
>
> Why would it change between 97 and XP?
>
> JW
- Next message: Bob Z.: "Re: MergeField Limits in tables?"
- Previous message: JW: "Table cell display differences between 97 and XP"
- In reply to: JW: "Table cell display differences between 97 and XP"
- Next in thread: JW: "Re: Table cell display differences between 97 and XP"
- Reply: JW: "Re: Table cell display differences between 97 and XP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
