I have a database with multiple tables linked to SharePoint lists. In some of the number fields I have selected "No" in more options for "Use thousands separator". The numbers are correctly displayed in the SharePoint lists but they still display with the thousands separator in the linked table in Access. I have refreshed the links with no success. I even tried change a linked table to local, renaming it and establishing a new link with no change. Can anyone help me figure out why the formatting isn't showing up in the linked tables in Access?
Thank You,
Merlin S