Format output to currency

[Micromanaged]

In my response.write line, I need to format a field to be a currency
value. Is there a quick and dirty way to do it or is it an involved
edit? Here is my code:

Response.Write("<td>" & WhataRecordset.Fields.Item(0).Value &
"</td><td>" & WhataRecordset.Fields.Item(1).Value & _
"</td><td>" & WhataRecordset.Fields.Item(2).Value & "</td><td>" &
WhataRecordset.Fields.Item(3).Value & _
"</td><td>" & WhataRecordset.Fields.Item(4).Value & "</td><td>" &
WhataRecordset.Fields.Item(5).Value & _
"</td><td>" & WhataRecordset.Fields.Item(6).Value & "</td></tr>")

The value written out in WhataRecordset.Fields.Item(2) is a monetary
amount and should be formatted in the currency format.

Thanks in advance.

 

[Aaron Bertrand - MVP]

Yes, have you tried the FormatCurrency() function? ;-)

 

[Micromanaged]

It just barely dawned on me stupid brain after I posted the question.
Long day and it is only half over.

Thanks, though.