Hi,

I hope you guys can help us. We have a routine that uses an ASC function call. The Routine using this produces 'invalid procedure call' error on certain unknown characters e.g.

    cLetter = Mid(strText, L, 1)
    cLetterASC = Asc(cLetter) <Error raised here

    debugging the cLetter variable we see the value as Nothing, null or Empty (Its not though!).

I suspect that the character is not ASC compatible. Does anyone know how to disregard Non ASC characters?

Jon

What is the error u get?

Before assigning value to cLetterASC, you can add a condition to check if the value of cLetter is not blank.



Om Prakash

Hi,

The error is:

Unexpected Error Message

Error 5 Occured
Invalid proedure call or argument

cLetter value:
cLetterASC Value:77

and the same for Value:67 and Value:79

Error is the L variable. It gets value somewhere.
Example:

strText="Some text"
L=15
cLetter = Mid(strText, L, 1) 'cLetter is empty
cLetterASC=Asc('empty') '=Error

Just like Om says you must check cLetter value before assigning value to cLetterASC

-vemaju