Help me control decimals & ","

[Dawnit]

I've tried everything I can think of!

Underlying table has number fields where I need various entries formated exactly like these examples:.05, .5, 1, 1.5, 250, 3500
field size is: Single
format is: General
decimal is: Auto

Report has text boxes with these settings:
format is: General
decimal is: Auto

Here is what I ultimately need one report to do:
If my table field says .05, I need my report to show .05
If table says .5, I need report to show .5 (NOT 0.5 or 0.50
If table says 1, I need report to show 1 (NOT 1.0 or 1.00)
If table says 3500, I need report to show 3,500
If talbe says 250, I need report to show 250 (NOT ",250&quot
and so on...

Here is what I tried regarding the comma problem in the report control: #,### which is forced to #/,### so that I get a comma for number in hundreds

I will be in great appreciation if someone can help me!!