Number Formatting

[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!

 

[Jeff Boyce]

You don't say where you are changing the format/display. Are you doing that
in the form's textbox? If so, how?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/