'Temperature' field saving w/ two numbers after decimal

P

Pat Dools

Hello,

I have a 'temperature field I am saving as a 'Decimal - Fixed' with a '4'
Precision and a '1' Scale and an 'Input Mask' of '999.9'. It keeps saving
values w/ a trailing zero. For example, '99.8' saves as '99.80'. I've tried
various combinations of the above settings, but that trailing zero is always
thrown in. I know that technically, '99.8' is the 'same' value as '99.80',
but the Access data is being read by another statistical program that will
expect '99.8'. How can I force this value to be '99.8'?

Thanks.
 
J

John Vinson

Hello,

I have a 'temperature field I am saving as a 'Decimal - Fixed' with a '4'
Precision and a '1' Scale and an 'Input Mask' of '999.9'. It keeps saving
values w/ a trailing zero. For example, '99.8' saves as '99.80'. I've tried
various combinations of the above settings, but that trailing zero is always
thrown in. I know that technically, '99.8' is the 'same' value as '99.80',
but the Access data is being read by another statistical program that will
expect '99.8'. How can I force this value to be '99.8'?

Thanks.
Click to expand...

Set its Format property to #.0

You'll also need to use the Format$() function in a calculated field
when you go to export the data - the export routine ignores input
masks and formats.

John W. Vinson[MVP]
 
P

Pat Dools

Thank you, John!

John Vinson said:
Set its Format property to #.0

You'll also need to use the Format$() function in a calculated field
when you go to export the data - the export routine ignores input
masks and formats.

John W. Vinson[MVP]
Click to expand...
 
Top