MS Access - Right Align Formatted number on a Form

Question

If I use Standard format for a number in a control then I can Align Right and it appears on the far right of the control in the Form. However, I am using numbers in millions and so want to format the number so that, for example, 50,123,456 will appear as 50.123. So I use format #,,.0 with decimal places set to 3. If I set alignment to left, it aligns to the left of the field on the form, Align Center and it appears in the center. But Align Right and there is a large space to the right of the number, like padding. Is there a way to get the formatted number to hit right up to the right side on the form?

Answer 1

Replace the ControlSource with the expression:

[Amount]/1000

Set property Format to: Fixed

Set property DecimalCount to: 0