'MS Access ignoring Format property when SQL column changed from FLOAT to DECIMAL

I have SQL Table, a View based on that table and an older MS Access database project (adp).

I have a FORM where datasource is the SQL View.

After I changed a column type from FLOAT to DECIMAL(19, 3), MS Access started to ignore regional settings (decimal separator) when displaying the column.

  • instead 1,2 it shows 1.200.
  • Even if I explicitly change the Field FORMAT to anything, it still shows the the wrong (native?) format

Any idea what's wrong?

sql-serverms-accessms-access-2010pythonphptelegramwebhooks


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions