If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting currency within a report text box expression
I'm trying to create a mail merge letter from a 2007 ACCB database using a
report (Word can't cope with the filter) To keep the text flowing to allow for expansion of various field values, I've put the following in a text box. ="According to my records you " & [Expr2] & " " & [KEYNO] & ", have made a total payment of " & [PAID] & " comprising a permit fee of " & [PERMIT£] & " and key deposit of " & [KEY£] & ". Therefore " & [Expr1] Ignoring Expr1 & 2 which are text statements and [KEYNO] which is a 4 digit integer The £0.00 values of [PAID], [PERMIT£] and [KEY£] simply won't display as 2dp currency values even though the text box format is so set and their query values are indeed currency. I could break up the expression into a number of boxes so that it does work but getting the letter layout right is a nightmare. Any suggestions welcome Pete |
#2
|
|||
|
|||
Formatting currency within a report text box expression
Pete,
You could try formatting the currency fields like this :- ....payment of " & Format([PAID],"Currency") & " compr.... Peter Hibbs. On Sat, 17 Apr 2010 06:11:01 -0700, Parish Pete wrote: I'm trying to create a mail merge letter from a 2007 ACCB database using a report (Word can't cope with the filter) To keep the text flowing to allow for expansion of various field values, I've put the following in a text box. ="According to my records you " & [Expr2] & " " & [KEYNO] & ", have made a total payment of " & [PAID] & " comprising a permit fee of " & [PERMIT£] & " and key deposit of " & [KEY£] & ". Therefore " & [Expr1] Ignoring Expr1 & 2 which are text statements and [KEYNO] which is a 4 digit integer The £0.00 values of [PAID], [PERMIT£] and [KEY£] simply won't display as 2dp currency values even though the text box format is so set and their query values are indeed currency. I could break up the expression into a number of boxes so that it does work but getting the letter layout right is a nightmare. Any suggestions welcome Pete |
Thread Tools | |
Display Modes | |
|
|