If there is no input mask or table format that conflicts, you should simply
be able to set the Format Property to: Currency
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
I have no input mask and the format for that column in
the detal section is set for currency. In the form
footer the box formatted for curreny with a sum formula.
However the it will not show currency.