Display decimal places

[Hans Recter]

I am have trouble getting numbers to display properly. I have a text box to
enter scores which can be either whole numbers or half points.

If I set the format to General Number the display is rounded up. If we enter
10.5 the display is 11 but the table shows 10.5.

If we use Fixed as the format with 1 decimal place we get 10.5 displaying OK
but the the whole numbers have a decimal place as 11.0.

Does anyone know how to have numbers display as they are entered?

Thanks for any help.
Hans Recter

 

[Guest]

Use format #.# for 1.1 or #.## for 1.12

 

[Hans Recter]

Thanks for your reply but there is still a space and decimal point if there
is no number. If possible I would like to display the numbers the same way
as they are shown in the table. (eg 10.5 or 11 not 11. )

 

[Guest]

This is untested --
Iif(right([YourNumField],1)=".", left([YourNumField], Len([YourNumField]) -
1), [YourNumField])