Users are getting Type Mismatch on 'Formatcurrency' when they scrolled to the bottom

[samytee]

The following lines of code return error message
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatCurrency'
/UnetER/sam_CCMSamEditRules_Bottom.asp, line 51

When users scrolled down the bottom of a report written in ASP and running on Windows 7


Here is the lines of code:

<% if objRecordSet("IncorrectAmount") = 0 then %> 
    <td align="right">*</td> 
<%else%> 
    <td align="right">
        <%=formatcurrency(objRecordSet("IncorrectAmount"))%>*
    </td> 
<%end if%>

[Rabbit]

You probably have a null value. You need to decide how you want to handle nulls.

[samytee]

For nulls, I want to display blank. How do I get around that?

[Rabbit]

Use an if structure.

[Frinavale]

Just to elaborate, in VB, null is Nothing.

Your if structure should check for Nothing.

For example:

If myVariable Is Nothing Then
  '...it is nothing
End If

However, your code appears to be taking from a Record Set (based on your variable name). So you need may need to check if the value is DBNull using the IsDBNull Function.

For example

If IsDBNull(myVariable) Then
  '... it is null/nothing
End If