I still havent solved the problem, so if anyone knows, help would be very appreciated.
Thanks!
User Profile
Collapse
-
Hi again.
Ive set the property to Numeric and I got data type mismatch. Then Ive changed the data type from Decimal to Double in Dataset (.xsd file). Tryed again, and everything is like I never changed anything: I enter 1,23, and I get 123 in the database.
Ive checked the content of dataset.designe r.vb file, and the data types are correct.
I've checked with CDec and I get 1,23 when I msgbox it. Ive also tryed...Leave a comment:
-
-
Hi Veena.
Yes, I forgot to state. I have comma as decimal separator.
MarkoLeave a comment:
-
Decimal separator in Access database
Hello all!
Situation is as follows:
- Access database file, decimal field (18,2)
- Visual Basic 2005
- ADO connection
When I put Datagrid on the form, I see the value correctly, and I can change it.
But, when I try to put a textbox on another form, referencing to the same data, the data reads correctly (for example: 1,23), but when I change it (to for example: 4,56) and save it, it saves...
No activity results to display
Show More
Leave a comment: