<div>
You are missing an end parenthesis for your Sum function.<br />

<pre><code class="code-1 nolinks" id="code-20-41797753-1"><span>format(Sum([Rpmt USD Equiv]),&quot;Currency&quot;)</span>
</code></pre>
</div>


<div>
Depending on your version of MS Access you can also use the FormatCurrency function.
</div>


<div>
Try with this:<br />
<br />
=&quot;Total for &quot;&nbsp;&amp; [cboPmtMadeYN] &amp;&nbsp;&quot; (USD Equiv):&quot; &amp;&nbsp;format(Sum([Rpmt USD Equiv]),&quot;Currency&quot;)
</div>


<div>
Shaun Kline is right. You are missing parenthesis for Sum Function
</div>


<div>
Hi,<br />
<br />
thank you. &nbsp;I thought that currency format would change the text color to RED if negative but I dont believe it will. &nbsp;<br />
<br />
I modified to the below but it still doesnt change the text font to red for negative. <br />
=&quot;Total for &quot;&nbsp;&amp; [cboPmtMadeYN] &amp;&nbsp;&quot; (USD Equiv): &nbsp;&quot; &amp;&nbsp;Format(Sum([Rpmt USD Equiv]),&quot;$#,##0.00;($#,##0<wbr />.00)[Red]&quot;<wbr />)<br />
<br />
Do you happen to notice my error?
</div>


<div>
For this you need conditional formatting<br />
You set &quot;less than &quot;&nbsp;0 and you change to your liking
</div>


<div>
Then Try this:<br />
<br />
=&quot;Total for &quot;&nbsp;&amp; [cboPmtMadeYN] &amp;&nbsp;&quot; (USD Equiv): &nbsp;&quot; &amp;&nbsp;Format(Sum([Rpmt USD Equiv]),&quot;$#,##0.00;(0)[Red<wbr />]&quot;)
</div>


<div>
The error was due to wrong value passed in parameter. You don't need to rewrite '$#,##0.00' in parenthesis before [Red].<br />
<br />
It will definitely solve your concern.
</div>


<div>
John, I believe conditional formatting would change the color of the entire text box. &nbsp;I only need the currency to be red. &nbsp; <br />
<br />
Dhara: &nbsp;that did not seem to be it either. &nbsp;<br />
<br />
let me know if you have another idea. &nbsp;thank you
</div>


<div>
It should work. I tried it.
</div>


<div>
This is in a report if that matters.
</div>


<div>
Conditional &nbsp;formatting affects font weight color and background....so use it as you like
</div>


<div>
Thank you. &nbsp;In my report, the red formatting doesnt seem to fire if the value is negative. &nbsp; I have no issue if i break the text box into its parts and leave the number in its own box. &nbsp;The issue with RED format not firing for negatives is when I consolidate it all in one text box. <br />
<br />
Let me know if you have any other ideas. &nbsp;Also note my text box is in a report.
</div>


<div>
for numbers, the first part of the format code is positive numbers, then negative numbers, then 0 (zero) then null. The data type must be a number, not a string.<br />
<br />
&quot;$#,##0.00;[Red]-$#,##0.00<wbr />&quot;;(0);&quot;&quot;
</div>


<div>
Hi Crystal: I seem to be getting a syntax:<br />
(I have pasted your comment from above into the format section in the following):<br />
=&quot;Total for '&quot; &amp;&nbsp;[cboPmtMadeYN] &amp;&nbsp;&quot;' (USD Equiv): &nbsp;&quot; &amp;&nbsp;Format(Sum([Rpmt USD Equiv]),&quot;$#,##0.00;[Red]-$<wbr />#,##0.00&quot;;<wbr />(0);&quot;&quot;)
</div>


<div>
you're welcome ~ happy to help<br />
<br />
the only reason I specified Null code was so you could see where to put some text in (ie: &quot;Fill this out&quot;, or whatever) -- leave it off if you are not going to do that
</div>


<div>
<div class="content wysiwyg-content">
Experts, I seem to have an error of &quot;too many arguments&quot; in the below:<br />
<br />
=&quot;Total for &quot;&nbsp;&amp; [cboPmtMadeYN] &amp;&nbsp;&quot; (USD Equiv):&quot; &amp;&nbsp;format(Sum([Rpmt USD Equiv],&quot;Currency&quot;)<br />
<br />
I need to format the [Rpmt USD Equiv] as currency.<br />
<br />
thank you
</div>
</div>


Experts, I seem to have an error of "too many arguments" in the below:

="Total for " & [cboPmtMadeYN] & " (USD Equiv):" & format(Sum([Rpmt USD Equiv],"Currency")

I need to format the [Rpmt USD Equiv] as currency.

thank you

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.