D
diana
Question: How to format a report to be able to suppress a trailin
decimal point for numbers greater than 1 (eg, 22 not 22.) and also b
to display a leading zero for numbers less than 1 (eg, 0.1) in the sam
text box?
Report contains text box named [calculated number], whose values range
from X.X to XX (positive numbers).
[calculated number] = [number]*0.1/2.
[number] is supplied by the end-user via a form.
[number]'s format = fixed with 1 decimal place.
I currently have the [calculated number]'s format = 0.# which work
fine for
numbers less than one but not for numbers greater than one (display
22.
instead of 22). How do I get the text box to display "22" and no
"22." while maintaing the ability to display 0.1 for number less tha
1?
Any information is much appreciated.
Regards,
VERY STUCK =
decimal point for numbers greater than 1 (eg, 22 not 22.) and also b
to display a leading zero for numbers less than 1 (eg, 0.1) in the sam
text box?
Report contains text box named [calculated number], whose values range
from X.X to XX (positive numbers).
[calculated number] = [number]*0.1/2.
[number] is supplied by the end-user via a form.
[number]'s format = fixed with 1 decimal place.
I currently have the [calculated number]'s format = 0.# which work
fine for
numbers less than one but not for numbers greater than one (display
22.
instead of 22). How do I get the text box to display "22" and no
"22." while maintaing the ability to display 0.1 for number less tha
1?
Any information is much appreciated.
Regards,
VERY STUCK =