Daffodil Computers Ltd.

Office Suite Tutorial => Microsoft Office Access => : bbasujon August 15, 2012, 05:23:12 AM

: Microsoft Access Function Library: Hex()
: bbasujon August 15, 2012, 05:23:12 AM
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"