SOLVED - Decimal points not saving in subform?
###### SOLVED ######
It turns out that that access didn't link the table properly and refreshing the list fixed this.
With all these issues I keep coming across and fixing myself it might actually help someone. xD
############
I'm using an Access 2007 frontend on a MySQL database and I have two subforms in a form.
Subform 1 is in form view and has a field that is set in the database as 2 decimal places, and in the subform field is set to Currency and 'Auto' decimal places.
Subform 2 is in datasheet view and has the database and fronent fields pretty much the same.
Here is what happens -
Subform 1's field:
When I type in 2000.54 in the field, it is saved as 2000.54 as shows up as £2000.54 .
Subform 2's field:
When I type in 2000.54 in the field, it is saved as 2000.00 as shows up as £2000.00, and then when I click away I get the message "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the change the other user has made" It then gives me the 3 options "Save Record, Copy to Clipboard, Drop Changes" and 'save record' is greyed out!
Also, this ONLY happens with the number in Subform 2, the text fields edit/change perfectly. What could be causing this? Thanks in advance!
###### SOLVED ######
It turns out that that access didn't link the table properly and refreshing the list fixed this.
With all these issues I keep coming across and fixing myself it might actually help someone. xD
############
I'm using an Access 2007 frontend on a MySQL database and I have two subforms in a form.
Subform 1 is in form view and has a field that is set in the database as 2 decimal places, and in the subform field is set to Currency and 'Auto' decimal places.
Subform 2 is in datasheet view and has the database and fronent fields pretty much the same.
Here is what happens -
Subform 1's field:
When I type in 2000.54 in the field, it is saved as 2000.54 as shows up as £2000.54 .
Subform 2's field:
When I type in 2000.54 in the field, it is saved as 2000.00 as shows up as £2000.00, and then when I click away I get the message "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the change the other user has made" It then gives me the 3 options "Save Record, Copy to Clipboard, Drop Changes" and 'save record' is greyed out!
Also, this ONLY happens with the number in Subform 2, the text fields edit/change perfectly. What could be causing this? Thanks in advance!
Last edited:
