Forum Discussion
In SharePoint List - Use Thousands Separator = NO is not displayed in Access tables linked to list
I am assuming that you will need to use either a query, or form for manipulating the data, or report for reporting purposes, instead of working directly within the tables. In any of three cases; you can use the Format property of the field in a query (1), or the Format property of the textbox in a form or report (2), by setting it to "General" or "Fixed", then set the Decimals property to the digits desired. Just to remind, Format never modifies the actual number data, it just changes the way how the data displayed to the user on the screen or on the report.
If none of these are helpful, can you please share more details about what do you want to do with the data in MS Access.
I am assuming that you will need to use either a query, or form for manipulating the data, or report for reporting purposes, instead of working directly within the tables. In any of three cases; you can use the Format property of the field in a query (1), or the Format property of the textbox in a form or report (2), by setting it to "General" or "Fixed", then set the Decimals property to the digits desired. Just to remind, Format never modifies the actual number data, it just changes the way how the data displayed to the user on the screen or on the report.
If none of these are helpful, can you please share more details about what do you want to do with the data in MS Access.
- Based on a discussion of this problem on MS Answers, I believe the only option is, as you suggest, formatting in a query or control on a form or report.
The solution suggested didnt work for me. I have the same issue and 12 years have passed. Is there any solution for this issue?
With a LOT more context about your exact situation, we might be able to venture a guess as to what the problem is and offer suggestions about what to do. I assume you tried formatting the numbers in a query? And to be honest, the comment about 12 years passing leaves me a bit puzzled. Twelve years since what?
Also, do keep in mind that the VALUE stored in a field is always the same VALUE, regardless of how it is FORMATTED FOR DISPLAY to a user. If you are concerned about appearance, it is worthwhile to apply formatting. However, for calculations and other purposes, formatting is irrelevant.
- Correct, you simplified it. Thank you.
