A Allen Browne Dec 20, 2005 #2 Prefix the hex value with &H, and use Val() to get the value as a decimal: Val("&H" & [YourHexField])
Prefix the hex value with &H, and use Val() to get the value as a decimal: Val("&H" & [YourHexField])
T tjeffryes Joined Jun 6, 2011 Messages 2 Reaction score 0 Jun 6, 2011 #3 This does not work for 2CB0. Return 715, when it should be 11440 Tim Jeffryes
T tjeffryes Joined Jun 6, 2011 Messages 2 Reaction score 0 Jun 6, 2011 #4 Sorry. I see what happened here - used an Oh instead of a zero. However, it did return 715, so I think CINT("&H" & [YourHexField]) works better. It returns an error if the HEX is invalid.
Sorry. I see what happened here - used an Oh instead of a zero. However, it did return 715, so I think CINT("&H" & [YourHexField]) works better. It returns an error if the HEX is invalid.
