I have an issue when saving a record on a form which contains Currency fields.
Example: the original value from the database was $26.11, however when I change another field on the form and save the record it changes it to $2,611.00.
As I investigate further it also happens to other forms where there is a currency field.
Details:
Database: SQL Server 2019
Field in Database is set to “Money”
Any suggestions would greatly be appreciated!
Best Regards,
Edward K.