Prev: Convert db to accde
Next: Format
From: SAC on 11 May 2010 14:36
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.


From: Dirk Goldgar on 11 May 2010 15:56
"SAC" <sac(a)somewhere.com> wrote in message
news:%23PSRsjT8KHA.1560(a)TK2MSFTNGP02.phx.gbl...
>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>

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

(please reply to the newsgroup)

From: Al Campagna on 11 May 2010 21:22
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" <sac(a)somewhere.com> wrote in message
news:%23PSRsjT8KHA.1560(a)TK2MSFTNGP02.phx.gbl...
>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.
>
>


From: SAC on 12 May 2010 10:47
That took care of it. Thanks, again.

"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message
news:A7D49CD2-BEEB-4991-B8ED-C76209AE9AEA(a)microsoft.com...
> "SAC" <sac(a)somewhere.com> wrote in message
> news:%23PSRsjT8KHA.1560(a)TK2MSFTNGP02.phx.gbl...
>>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>
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>

 | 
Pages: 1
Prev: Convert db to accde
Next: Format