Number Alignment to decimal place

[Guest]

I am running a report where the numbers are all alligned to the right and
have the properties listed below. (I am able to use the Format,Align and
size commands to easily create the fields with the same size and alignment ):

Report:
Std 3.9
Actual 4.5
% Achieved 0.9
Distribution 25.0
Points 21.2

Format: Fixed
Decimal Places: 1
Font Name: Times New Roman
Font Size: 11
Font Weight: Normal

I am now running a report which requires percentages and numbers with
different decimal places. The report no longer is aligned. Notice that %
Achieved and Distribution no longer align with the other numbers. Is there a
simple solution or do I have to move each field meticulously arround until
alignment is achieved ?

Report:
Std 3.9
Actual 4.5
% Achieved 86.8%
Distribution 25
Points 21.2

 

[Duane Hookom]

I believe the solution is called "Nudge-Preview-Nudge-Preview-..."

 

[Arno R]

I think I would use two textboxes side by side.
One for the integer part (aligned right) and one for the decimal portion (left aligned)
The second textbox would also present the separator (.) but only if there is a decimal value.
I guess you can work this out?

HTH

Arno R

 

[OfficeDev18 via AccessMonster.com]

As for your % achieved number, simply leave off the "%" sign. You already
have it in the line heading so everyone will know it's a percentage. As for
the Distribution number, it must have had its decimal place setting (1)
replaced somehow with either '0' or 'Auto'. All you have to do is go into the
property sheet and reset it to '1'.

HTH