jdmartin74
Programmer
I have a report displaying numbers for different countries. I can identify each country but wish to display the numbers differently for each. For example, 10,453.56 for a UK number and 10.453,56 for a French/German etc. number.
Access is always using my default locale but I need this to change on a per record basis. Using the field format with something like "##,##0.00" and "##.##0,00" is not handled correctly; it basically reads my locale.
Does anyone know of a solution to this short of simply mashing the strings and doing a search and replace?
Access is always using my default locale but I need this to change on a per record basis. Using the field format with something like "##,##0.00" and "##.##0,00" is not handled correctly; it basically reads my locale.
Does anyone know of a solution to this short of simply mashing the strings and doing a search and replace?