Hex2Dec() for VisualBasic

K

Kolob

I havn't found a way to complete this in access. I always
have to do it in excell. Please help and thanks in advance.
Kolob
 
D

Douglas J. Steele

Append &H in front of the Hex value, and use CLng to convert to a long.

Rather than HEX2DEC("A5"), you'd use CLng("&HA5")
 
Top