formatting from a database in Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DowningDevelopments - 08 Feb 2006 15:17 GMT

hey everyone,
I had this working a few weeks ago but ive upgraded my database from Access
2000 to Access 2003 and now i have lots of formatting problems with
calculated values in an access query that i want to format as currency.

Im using the following and works as long as its not part of an IF statement,

{MERGEFIELD "M_42Pay1" \#"£0000.00}

works great and brings up the correct value as a currency just fine!
but i really need this in a statement like this:

{If {MERGEFIELD "GarantorsSname}<> "" "Payment 1: {MERGEFIELD "M_42Pay1"
\#"£0000.00} Due on Mergefield "M_06pay1dateHome"}

And this doesnt format that same value correctly, it shows it as a plain
number!!
Also how do i get subsequent payments to line up underneath this one?

{If {MERGEFIELD "M_42Pay2"} ="£0.00" {"Payment 2: {MERGEFIELD "M_42Pay2"
\#"£0000.00} Due on Mergefield "M_06pay2dateHome"}

should bring up the second payment due, however instead of a neat:

Payment 1: £1000 due on 01/01/2006
Payment 2: £1000 due on 01/03/2006

i get: Payment 1: £1000 due on 01/01/2006Payment 2: £1000 due on 01/03/2006

All on one line with no spaces or formatting, ive tried putting in
breaklines and paragraph marks in the IF quotations and between the blocks of
code but its not working!!!

can you help me on either (& hopefully both) of these problems?

Reply to this Message

Doug Robbins - Word MVP - 08 Feb 2006 19:32 GMT

The field construction should be

{ If { MERGEFIELD GarantorsSname}<> "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£0000.00"} Due on { Mergefield M_06pay1dateHome}" }

Each pair of field delimiters must be inserted using Ctrl+F9

Signature

Hope 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

> hey everyone,
> I had this working a few weeks ago but ive upgraded my database from
[quoted text clipped - 4 lines]
> Im using the following and works as long as its not part of an IF
> statement,

> works great and brings up the correct value as a currency just fine!
> but i really need this in a statement like this:
[quoted text clipped - 23 lines]
>
> can you help me on either (& hopefully both) of these problems?

Reply to this Message

Graham Mayor - 09 Feb 2006 08:19 GMT

Or even

{ If { MERGEFIELD GarantorsSname } <> "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£,0.00" } Due on { Mergefield M_06pay1dateHome \@ "dd/MM/yyyy" }{ If
{ MERGEFIELD M_42Pay2 \# "0" } = 0 "¶Payment 2: { MERGEFIELD M_42Pay2 \#
"£,0.00" } Due on { Mergefield M_06pay2dateHome \@ "dd/MM/yyyy" }" }" }

Assuming that all this is only entered if the GarantorsSname field has
content then will also show the second field when the content is 0. Press
the enter key where the ¶ symbol is. Watch out for spacing and quotes. The
currency switches will include commas as thousands separators and date
switches are added to force your preferred date format.

If the second line is independant of the Garantorsname field content then
that part of the statement needs to be moved outside the first conditional
field thus:

{ If { MERGEFIELD GarantorsSname } <> "" "Payment 1: { MERGEFIELD M_42Pay1
\# "£,0.00" } Due on { Mergefield M_06pay1dateHome \@ "dd/MM/yyyy" }" }{
If { MERGEFIELD M_42Pay2 \# "0" } = 0 "¶Payment 2: { MERGEFIELD M_42Pay2 \#
"£,0.00" } Due on { Mergefield M_06pay2dateHome \@ "dd/MM/yyyy" }" }

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> The field construction should be
>
[quoted text clipped - 39 lines]
>>
>> can you help me on either (& hopefully both) of these problems?

Reply to this Message

Rate this thread: