I have a field (UnitPrice) in a table with Currency data type.
The report shows the field as General Number.
If I change the format property of the text box to Currency, still the report shows the field as general number.
If I change the format property of the text box to $#,##0;($#,##0), still the report shows the field as general number.
If I make the textbox unbound and use the following for its controlSource property, report shows it as currency.
= cCur(UnitPrice)
Is this behavior normal?
thanks
The report shows the field as General Number.
If I change the format property of the text box to Currency, still the report shows the field as general number.
If I change the format property of the text box to $#,##0;($#,##0), still the report shows the field as general number.
If I make the textbox unbound and use the following for its controlSource property, report shows it as currency.
= cCur(UnitPrice)
Is this behavior normal?
thanks