Convert text to hex2dec

[mohsin]

Hi

Appreciate for your help,


My value = 319,A03,B13,16, which is in text format. The numbers actually are
in hex value. What i need to do now is, convert the value from text to hex
then to decimal,

i'm using below expression for converting to hex, but is wrong..

CCDec: Val(Replace([tblclearcode]![CLEARCODE_ID],",",""))

Can someone help me please,

thank you

 

[Guest]

I came across this in another post a while back.

*****
The function you need is

Variant=CDEC("String")

Where String is the hex number prefixed with &H

Thus

MsgBox CDec("&HC1A")

would output 3098
*****

Daniel

 

[mohsin via AccessMonster.com]

HI daniel

Thanks,

But how i can present it in my query, instead of using msgbox,

br, mohsin

I came across this in another post a while back.

*****
The function you need is

Variant=CDEC("String")

Where String is the hex number prefixed with &H

Thus

MsgBox CDec("&HC1A")

would output 3098
*****

Daniel

Hi

[quoted text clipped - 11 lines]

thank you