I have a report in MS Access XP with a textbox bound to number field. I want to display the number as 12 123,12 (a space for the thousands separator, a comma as decimal point and 2 decimals).
In the format property of the textbox I type in ##\ ##0,00
Access doesn't accept this setting and changes it to # 0,0 witch gives a wrong result.
Can anyone help me with this ?
In the format property of the textbox I type in ##\ ##0,00
Access doesn't accept this setting and changes it to # 0,0 witch gives a wrong result.
Can anyone help me with this ?
