Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numeriv value has too many decimal digits

Status
Not open for further replies.

Niebotel

Programmer
Jan 1, 2007
169
NL
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?
 
What do you mean? English is not my language
 
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.
 
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?
 
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!
 
OK; I will change nothing.

Thanks for helping
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top