I´ve had a problem using comma as decimal separator, i´d like to input (999,34) as a value and got an error 80040e14 - Number of query values and destination fields are not the same.
The solution i found was setting the DB field as Currency, and input value in INSERT or UPDATE form as TEXT. That way the field is correctly updated and displayed.
Comments
Use . instead ,
I think you need use . instead ,
You need to check your localization settings.
You must me logged in to write a comment.