By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Error with formatcurrency statement

P: n/a
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.
Jul 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
The quick and dirty fix:

FormatCurrency("0" & TotPersonnel)

Ray at work
"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:30**********************************@microsof t.com...
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.

Jul 21 '05 #2

P: n/a
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:<uL**************@TK2MSFTNGP10.phx.gbl>...
The quick and dirty fix:

FormatCurrency("0" & TotPersonnel)


Great idea... can't believe I never thought of it! :-)
Jul 21 '05 #3

P: n/a
Yeah, it handles nulls and empties all in one swoop. :]

Ray at work

"Larry Bud" <la**********@yahoo.com> wrote in message
news:5d**************************@posting.google.c om...
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:<uL**************@TK2MSFTNGP10.phx.gbl>...
The quick and dirty fix:

FormatCurrency("0" & TotPersonnel)


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

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.