Alignment of Zero Values

[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.

 

[J_Goddard via AccessMonster.com]

Hi -
Did you try right-justifying the report field?

John

 

[Marshall Barton]

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....

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 ;-)

 

[Craig]

Thanks. That seemed to do the trick.
--
Craig

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 ;-)