function to find ASCII Value

[MArio]

What is the function to find the ASCII value for a
character in ACCESS like 'A' is 65/63 or what ever

Please help

thanks
mario

 

[Cheryl Fischer]

The Asc() function should do it:

From VBA Help, here is how it is used.

Dim MyNumber
MyNumber = Asc("A") ' Returns 65.
MyNumber = Asc("a") ' Returns 97.
MyNumber = Asc("Apple") ' Returns 65.