By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Field in Access Form rounds the data to 4 places.

P: 6
In the Form in my Access Db only one particular field (rate field) automatically rounds the entered data to 4 decimal places. I need the entry to show 6 decimal places so that the calulation performed in another field is accurate.

There are other rate fields in the form that correct show 6 decimal places and calculate correctly..

I checked the format properties of the problem field and even compared them with the correctly operating fields and found nothing different.

Could anyone tell me what could be the cause and possibly remedy?

Thanks
Sep 5 '07 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
We'll need to know a bit more information to give any reasonably intelligent responses :-)

Are these fields derived from calculations, or are they data entered as is?
What are the table level field specifications for each field?

If derived from calculations, where do these calculations reside? VBA? Query? What do they look like?

If derived from calculations, are you sure that there are more than 4 decimal places being returned by the calculation?

If calculated in VBA (or in a query), are they being passed through a Round([Value],[Xdecplaces]) function?

Regards,
Scott
Sep 6 '07 #2

P: 6
Scott,

Thanks for responding.

These feilds are entered as data in a form with 6 decimal places. But somehow the field displays only 4 places by rounding up the number. The field property in the table and the form are set to 6 decimal places.

No rounding function has been used.

Regards,

Farouk

We'll need to know a bit more information to give any reasonably intelligent responses :-)

Are these fields derived from calculations, or are they data entered as is?
What are the table level field specifications for each field?

If derived from calculations, where do these calculations reside? VBA? Query? What do they look like?

If derived from calculations, are you sure that there are more than 4 decimal places being returned by the calculation?

If calculated in VBA (or in a query), are they being passed through a Round([Value],[Xdecplaces]) function?

Regards,
Scott
Sep 10 '07 #3

Scott Price
Expert 100+
P: 1,384
Check to make sure that the table level specification is set to Double as well as the decimal places to 6.

Otherwise try creating a new field in your table with a data type of Number/Double and set the decimal places to 6, bind the control on your form to the new field and see if it still displays 4 decimal places. (It's wise to do this type of checking on copies of the objects you are changing.)

Regards,
Scott
Sep 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.