Microsoft Access Function Library: Hex()

[bbasujon]

Function: Hex()

Purpose: The Hex() function converts a whole number into a string containing its hexadecimal representation.

Usage: Hex(value)

Value is a numeric or string expression that evaluates to a number. If it evaluates to a decimal number, Hex() rounds it to the nearest whole number prior to conversion.


Returns: String containing the hexadecimal value.

Examples and Special Cases

Hex(12)= "b"
Hex(125)= "7d"
Hex(125.4)= "7d"
Hex(125.6)= "7e"