Setting the proper decimals - Help

[Marly]

I read all the previously posted questions, but this time mine is different.
I need high precision since I use the column for calculation. I have a
column with
Data Type = Number
fieldsize = double
Decimal places = 1

Because I want to keep all the numbers after the decimal to have precise
calculation (ex: 84.6246264748467), but I want it to display in the table
84.6
This is why I set the decimal to 1. But it is not displaying the way I
want, is there something that I can do for that?

Thanks a million
Marly

 

[Duane Hookom]

Yes, there is probably something you can do ... start by explaining what you
mean by "not displaying the way I want".

 

[John W. Vinson]

Because I want to keep all the numbers after the decimal to have precise
calculation (ex: 84.6246264748467), but I want it to display in the table
84.6

Solution:

Don't look at the Table.

Tables are for data storage, not for data editing or display. To print the
data create a Report; to view it onscreen create a Form.

In either case, you can set the Format property of a textbox bound to the
number field to

#.0

to display one and only one decimal.

John W. Vinson [MVP]

 

[Marly]

Thanks a million, will do.

Marly

Solution:

Don't look at the Table.

Tables are for data storage, not for data editing or display. To print the
data create a Report; to view it onscreen create a Form.

In either case, you can set the Format property of a textbox bound to the
number field to

#.0

to display one and only one decimal.

John W. Vinson [MVP]