I have text boxes on a form that show currency set to no decimals. The spaces reserved for the decimals show to the right of the amount. Is there any way to eliminate the empty space to the right of the amount so there is no space gap on the right? Thanks. Jim

In design mode, select the control and format it to right align

J

That doesn't work when you round to no decimals.

If you don't intend to do any calculations with the numbers, one possible solution would be to make them into a string - for example, having:
YourMoney: "$" & Int(TheMoneyField)
in the query
then right aligning the textbox that it goes into.



I am a loud man with a very large hat. This means I am in charge

Thanks. That gives me something to think about. Jim

I don't understand the problem. I use Access97 and currency with no decimals is right aligned.

Clive Astley

 _____________
 | $100,000 ^|
 ------------^-
                  Space between the last zero and the right side of the text box.