Prev: Sharepoint 2007 lookup field showing up as memo in Access 2003
Next: Database integrity
From: frets55 on 24 Feb 2010 10:24
I am sending letters to individuals who have an account balance using merge
fields from an access database. Works well unless the last digit is a zero -
then it gets dropped (ie $481.10 looks like $481.1). In the Access database,
I have the field set up as currency with 2 decimal places. Any ideas? Thanks
in advance.


From: Mark Andrews on 24 Feb 2010 15:26
Here's an article that should help:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

You either change the word document so it formats the merge fields better or
you change
the data that is merged (example: use Format(Thefield,"$###.00") and send a
string instead of a number to word.

Both methods have merits.

HTH,

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com


"frets55" <frets55(a)discussions.microsoft.com> wrote in message
news:A1AFEA8B-3982-4329-A065-A67E10C6F2FC(a)microsoft.com...
> I am sending letters to individuals who have an account balance using
> merge
> fields from an access database. Works well unless the last digit is a
> zero -
> then it gets dropped (ie $481.10 looks like $481.1). In the Access
> database,
> I have the field set up as currency with 2 decimal places. Any ideas?
> Thanks
> in advance.
>
>
From: De Jager on 13 Mar 2010 12:59

"frets55" <frets55(a)discussions.microsoft.com> wrote in message
news:A1AFEA8B-3982-4329-A065-A67E10C6F2FC(a)microsoft.com...
>I am sending letters to individuals who have an account balance using merge
> fields from an access database. Works well unless the last digit is a
> zero -
> then it gets dropped (ie $481.10 looks like $481.1). In the Access
> database,
> I have the field set up as currency with 2 decimal places. Any ideas?
> Thanks
> in advance.
>
>

 | 
Pages: 1
Prev: Sharepoint 2007 lookup field showing up as memo in Access 2003
Next: Database integrity