Check out the following piece of code.

Private Sub Form_Load()
Dim V1 As String
V1 = "£0.00"
MsgBox "about to do clng of v1"
If CLng(V1) = 0 Then
MsgBox "Just did clng of v1, val = 0 "
Else
MsgBox "Just did clng of v1, val != 0 "
End If
End Sub

On my machine, it works fine. On another, the line with CLng in it terminates the program with a `run-time error 13: type mismatch`.

I know CLng uses your locale settings, but this is unacceptable, isnt it? Or is it my fault. I`m sure i`ve had this problem before and its `gone away`, though its not going anywhere at the moment!

Perhaps a few of you could check this out and see what happens on your machine?


Thanks,
Alex.