Numeriv value has too many decimal digits

[Niebotel]

I have a numeric field which is defined as a numeric field, double precision and two decimal digits; the table is migrated to a sharepoint table (some time ago) and now attributes can only be changed in the sharepoint table. So not in Access anymore.
In the sharepoint the field is defined as numeric with 2 digits.
On the form the field is also defined as two digits.
But if I click on the value in the field on the form a figure shows up with a lot of digits. How can I solve this inconvinient?

 

[SkipVought]

...for instance...?

 

[Niebotel]

What do you mean? English is not my language

 

[SkipVought]

You may have a field that has a FORMAT to displays 2 decimals, but the underlying value may have more than 2 decimal places, for instance

Display: 4.24

Value: 4.23592

Your format does not limit the actual value. It only limits what you see displayed.

 

[Niebotel]

Hi SkipVought,
I understand, but I would assume that the format keeps working when i click on the field; so that is not the case.
Users are confused by that.

Because I cannot change the definition of the underlying field (Sharepoint field). Is there a way to change it in VB or other trick?

 

[SkipVought]

You'll see this in other applications, so what's the big deal?

Formatting a column of numbers changes nothing except what is displayed. If you go to edit a specific value, you see the unformatted value in the formula bar. That's just how it works!

 

[Niebotel]

OK; I will change nothing.

Thanks for helping