label and currency textbox

[SAC]

I have a label with a textbox directly underneath it. The are aligned to
the right.

The textbox contains a currency amount and yet they do not display aligned.

How can I make the last character of the label line up with the last decimal
of a currency value?

Thanks for your help.

 

[Dirk Goldgar]

I have a label with a textbox directly underneath it. The are aligned to
the right.

The textbox contains a currency amount and yet they do not display
aligned.

How can I make the last character of the label line up with the last
decimal of a currency value?

Although I can't see your form (or report), my guess is that the
misalignment occurs because the "Currency" format allows for enclosing
parentheses to represent a negative value. If that is the problem, you can
....

A. Move the label over so that positive values appear correctly aligned, or

B. Change the format from "Currency" to a user-defined format such as:

$#,##0.00;-$#,##0.00

C. Ignore the issue. <g>

 

[Al Campagna]

SAC,
That doesn't appear to make sense. If both the label and the currency
are right
aligned they should always line up... last label character to last decimal.

Some Label
123.45
or
Some Label
8.12

Please give some examples...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

 

[SAC]

Thanks, Dick!

Although I can't see your form (or report), my guess is that the
misalignment occurs because the "Currency" format allows for enclosing
parentheses to represent a negative value. If that is the problem, you
can ...

A. Move the label over so that positive values appear correctly aligned,
or

B. Change the format from "Currency" to a user-defined format such as:

$#,##0.00;-$#,##0.00

C. Ignore the issue. <g>

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 

[SAC]

That took care of it. Thanks, again.

Although I can't see your form (or report), my guess is that the
misalignment occurs because the "Currency" format allows for enclosing
parentheses to represent a negative value. If that is the problem, you
can ...

A. Move the label over so that positive values appear correctly aligned,
or

B. Change the format from "Currency" to a user-defined format such as:

$#,##0.00;-$#,##0.00

C. Ignore the issue. <g>

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 

[SAC]

Looks like it was a formatting problem where currency was allowing for the
( ) for negative numbers so Dick Goldgar recommended using a format - -
$#,##0.00;-$#,##0.00 and that fixed it.

Thanks for your help. I really appreciate it.