Alignment of Zero Values

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am using Access XP. I have this re-occurring problem regarding alignment
of numbers in reports.

For numbers, I always overwrite the existing format and replace it with
something like the following: $#,###.00;($#,###.00);-;-

The zeros will be replaced with a "-". However, the zero values never
"right-align" with any existing values. They are always a space or two over.
Example:

$1,299.00
$2,389.00
-
-
3,500.00

etc....

Anyone else run into this issue?

Thanks for the help.
 
Craig said:
I am using Access XP. I have this re-occurring problem regarding alignment
of numbers in reports.

For numbers, I always overwrite the existing format and replace it with
something like the following: $#,###.00;($#,###.00);-;-

The zeros will be replaced with a "-". However, the zero values never
"right-align" with any existing values. They are always a space or two over.
Example:

$1,299.00
$2,389.00
-
-
3,500.00

etc....
Click to expand...


That's because of the ) in the negative format. Access
takes care of it automatically for positive values, but not
for a constant string such you are using.

Try using something like:

$#,###.00;($#,###.00);"- ";"- "

with however many spaces after the - makes you happy ;-)
 
Thanks. That seemed to do the trick.
--
Craig


Marshall Barton said:
That's because of the ) in the negative format. Access
takes care of it automatically for positive values, but not
for a constant string such you are using.

Try using something like:

$#,###.00;($#,###.00);"- ";"- "

with however many spaces after the - makes you happy ;-)
Click to expand...
 
Back
Top