Form number not showing commas

[Paul Wagner]

Item A is in a table as currency. Item A also winds its way up from subqueries into a final query that is used on a form. However, the form does not show it as currency nor with commas. When I try changing the format property the drop down shows nothing and even if I type Fixed or Standard, it ignores it. Anyone know why and how can I fix this?

 

[sonny]

Try using this in the format for that table

$#,##0.00;-$#,##0.00

 

[Pat Hartman]

You are probably turning the number into a string in your query. That is why you are not seeing the normal numeric formats in the form's controls.

 

[Paul Wagner]

Perhaps.

I am using a Grouping in the subquery using this:
AmtCol1: Max(IIf([BudgetYear]=fnctGetStartYrB(1),[BudgetAmt],''))

How would I know if I am turning it into a string?

The format #,000.00 did not work