FormatCurrency Type Mismatch

[sila]

Hello can anyone help me. I am getting this error message below for the code following it (the whole line is line 473)

ERROR...

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'FormatCurrency'
/appcontracts/searchresults.asp, line 473

CODE....

<li> <%=(Recordset2.Fields.Item("Sub-Category2").Value)%>&nbsp;(<%response.write(FormatCurrency(Recordset2.Fields.Item("Min Value Agreed").Value,0))%>&nbsp;-&nbsp;<%response.write(FormatCurrency(Recordset2.Fields.Item("Max Value Agreed").Value,0))%>) <br>

Thanks

 

[ralphtrent]

formatcurreny is not a built in vbscript function. You need to create one your self.

 

[tsuji]

Note: I don't know what happens to my posting to a duplicated thread 329-852406. Must be deleted due to duplication.

Here is the reposting of my message.

Hello sila,

Formatcurrency() will throw a type-mismatch runtime if the expression is =null, or =empty, or empty string ="", or string not convertible to number such as ="$100" or ="abc123".

In your case, the way out is to control those item values befire passing to the response.write.

regards - tsuji

- tsuji

 

[PHV]

ralphtrent take a look here:

http://msdn.microsoft.com/library/en-us/script56/html/vsfctformatcurrency.asp

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sila]

Thanks for your responses. tsuji,I got yours before it disappeared, thanks. We added IsNull to the code as it was struggling to bring back <NULL> value and it worked.

Cheers!

 

[ralphtrent]

Hmm you learn something new everyday. If I only new that months ago, I could have save some agrevation