label and currency textbox

  • Thread starter Thread starter SAC
  • Start date Start date
S

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.
 
SAC said:
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?
Click to expand...


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>
 
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."
 
Thanks, Dick!

Dirk Goldgar said:
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)
Click to expand...
 
That took care of it. Thanks, again.

Dirk Goldgar said:
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)
Click to expand...
 
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.
 
Back
Top