Same forms act differently in different databases

[Dave14867]

Hello all,



I have run into an interesting issue this evening. I have a form that I copied from 1 database to another. 1 field in a subform works great in the first database, the same field in another acts differently. The field contains a currency value and when entered it can contain a value like 0.578125.

In the first database it works perfectly, it shows 0.58 but the 0.578125 is actually held as the value and that value is later used in a calculation.

In the second database it works differently, it shows 0.58 but the 0.5781 is actually held as the value, and this doesn't calculate correctly, it needs all of the decimal places, ie. it can't be rounded off.

Can someone shed some light on why this is happening please?

Thanks

Dave

[Gicu]

Have you checked the datatypes in the underlying tables in both dbs?

Cheers,
Vlad

[isladogs]

The data in each field is stored in the table NOT the form
So the table design must be different in the table in each database

As an example, the 3 number fields in this table are all DOUBLE datatype and have decimal places set as 4,6,2 respectively



Notice that the tables are actually storing numbers with more than the specified number of decimal places

Next I'll change the Format for all 3 fields to Fixed in the table design
Now the fields show the number of decimal places specified in the design



However the data stored hasn't changed - if I remove the Fixed format, the original data is seen again

Also if I use the data in a calculation, it uses all the decimal places whether or not they are visible
... UNLESS I specifically prevent that happening by using a function like ROUND or INT or FIX

You need to look at the actual data stored in your table

Hope that helps

[Dave14867]

Thank you so much, that was it, for some reason then tables were formatted differently and I never noticed it. I had checked that the forms were both formatted the same but didn't check the tables because I thought they would have been the same.

Thank You Gicu and Colin

Dave