I have a text box on a form that displays some calculation based on the form. All is working well but sometimes I have to display a decimal and other times a whole number. This number represents month(s) so if the value is whole I don't want to display a decimal and when its not whole I want to display to one tenth of the value.
i.e. 12 months vs. 0.5 months.
I'm using Format (MyVariable, "0.0") which works OK but then the decimal is always displayed.