If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
label and currency textbox
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. |
#2
|
|||
|
|||
label and currency textbox
"SAC" wrote in message
... 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) |
#3
|
|||
|
|||
label and currency textbox
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" wrote in message ... 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. |
#4
|
|||
|
|||
label and currency textbox
Thanks, Dick!
"Dirk Goldgar" wrote in message ... "SAC" wrote in message ... 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) |
#5
|
|||
|
|||
label and currency textbox
That took care of it. Thanks, again.
"Dirk Goldgar" wrote in message ... "SAC" wrote in message ... 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) |
#6
|
|||
|
|||
label and currency textbox
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. "Al Campagna" wrote in message ... 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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|