Prev: Send Access Report to MS Word
Next: Sum the values between start and end date
From: Nyima on 16 Dec 2009 13:25

From: Al Campagna on 16 Dec 2009 16:16
Nyima,
Format : Standard
Decimal Places : 2
OR
Format : +#,###.00;-#,###.00;.00;.00
Decimal Places : 2
This last example will display...
+1,234.56 for positive numbers
-1234.56 for negative numbers
.00 for zero values
.00 for null values

Place your cursor in the format property box, and hit F1.
That will display Help on formatting all types of data values.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Nyima" <Nyima(a)discussions.microsoft.com> wrote in message
news:40E17A68-150F-4887-8AAF-A82335044AFF(a)microsoft.com...
>


From: Marshall Barton on 16 Dec 2009 16:48
Nyima wrote:
[Nothing]


An example of what you want might get you a useful answer
more quickly than when we have to guess.

Set the Format property of the text box that calculates the
total to use whatever you want. Maybe as simple as #,##0,
but that's just a guess. See VBA Help for
Format Property - Number and Currency Data Types
for a list of the formatting specification codes.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Send Access Report to MS Word
Next: Sum the values between start and end date