G
Guest
This is going to sound really simple but I can't get this to work!
I have a query where there is a column of numbers in this format - #,##0.00
or
-#,##0.00 (minus numbers). In a form I have a text box that displays these
numbers based on a selection from a combo box.
My problem is that the numbers are displayed as ###0.00 or -###0.00, without
the comma seperator. I've tried to change the format to Standard on the
properties box and also added my own format and nothing changes the display.
Do I need to change the underlying query or is there something else missing?
Any help gratefully received!
I have a query where there is a column of numbers in this format - #,##0.00
or
-#,##0.00 (minus numbers). In a form I have a text box that displays these
numbers based on a selection from a combo box.
My problem is that the numbers are displayed as ###0.00 or -###0.00, without
the comma seperator. I've tried to change the format to Standard on the
properties box and also added my own format and nothing changes the display.
Do I need to change the underlying query or is there something else missing?
Any help gratefully received!