<div>
from the description you posted above, we need to see the db why it is not working.<br />
<br />
upload a copy of the db
</div>


from the description you posted above, we need to see the db why it is not working.

upload a copy of the db

<div>
Yes, I was using NZ and the suggestion...<br />
<br />
Val(NZ([yourField], 0))<br />
<br />
is working perfectly.<br />
<br />
Just as a side note, in the design of the report I have the fields lining up perfectly right-justified vertically but they are off by a space or two and I'm having to manipulate them to line up.<br />
<br />
--Steve
</div>


Yes, I was using NZ and the suggestion...

Val(NZ([yourField], 0))

is working perfectly.

Just as a side note, in the design of the report I have the fields lining up perfectly right-justified vertically but they are off by a space or two and I'm having to manipulate them to line up.

--Steve

<div>
<div class="content wysiwyg-content">
I have a field on a report that will not let me format it as currency.<br />
<br />
I do have the format set as currency. &nbsp;The field's control source, coming from a query, in the query is set to be formatted as currency but it still won't format as currency on the report.<br />
<br />
???
</div>
</div>


I have a field on a report that will not let me format it as currency.

I do have the format set as currency.  The field's control source, coming from a query, in the query is set to be formatted as currency but it still won't format as currency on the report.

???

Field on report won't format as currency

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.