In this database some of the text boxes need to be/show something like
88.9.
in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.
I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.
so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9
but I need to display and store only single decimal places with no
rounding.
how can I fix this?