Error with formatcurrency statement

[Jack]

Hi,
I got the following line in the formatcurrency statement that is giving error.
Response.write "<TD ALIGN=RIGHT WIDTH='10%' >" &
FormatCurrency(TotPersonnel) & "</TD>" & vbCRLF

The error message is:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'formatcurrency'
/gwisprod/FSR_EditDetailPrint.asp, line 345

I found out that if TotPersonnel field contains null value, the above error
gets generated. Any help is appreciated here. Thanks.

 

[Ray Costanzo [MVP]]

The quick and dirty fix:

FormatCurrency("0" & TotPersonnel)

Ray at work

 

[Larry Bud]

The quick and dirty fix:

FormatCurrency("0" & TotPersonnel)

Great idea... can't believe I never thought of it!

 

[Ray Costanzo [MVP]]

Yeah, it handles nulls and empties all in one swoop. :]

Ray at work