isnull not wokring on second check

[tania20]

Hi, I have the following code. The weird thing is that if both the fields are null or not null then the code works fine but if one or the other is null then i get a type mismatch error. I have no idea whats causing this!!!

                       If IsNull(rs![Price_B]) Then

                        Else
                            rs![Price_B] = Format(IIf((rs![Price_B] > 0), (rs![Price_B] / 100 + 1), (100 / (rs![Price_B] * -1)) + 1), "#0.00")

                        End If

                        If IsNull(rs![Price_H]) Then

                        Else
                            rs![Price_H] = Format(IIf((rs![Price_H] > 0), (rs![Price_H] / 100 + 1), (100 / (rs![Price_H] * -1)) + 1), "#0.00")
                        End If [Code/]

 

[PHV]

What about using [!]Val([/!]Format(...)[!])[/!]

Or simply the Round function instead of Format ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886