I have built several projects since last 15 years using different formatting for Indian Rupee (INR) and Japanese Yen (JPY) currencies comma separators.
Somewhere along the time, probably when it changed from Win 7 to Win 10 or from Win 10 to Win 11 now, it stopped working correctly.
I set the OS regional system currency to INR (1,00,00,000) format and it works fine for all INR currency values (₹1,00,000.00) by simply selecting "Currency" format in Access.
For JPY currency values, I used the general format as recommended in MS help files as (Â¥#,##0;"-Â¥"#,##0) in Access.
Initially this was working fine showing as (Â¥1,000,000) as required.
At some stage of the Windows and Access evolution, it started showing as (Â¥10,00,000) like INR format.
As it was not a major issue for user, I let it run.


Now I am upgrading the whole system with several projects with new versions and would like to set this issue straight for new users especially.
Perhaps I am missing out some basic setting.