Returns a String representing the hexadecimal value of a number.
Syntax
Hex( number )
The required numberargument is any valid numeric expression or string expression.
Remarks
If number is not already a whole number, it is rounded to the nearest whole number before being evaluated.
If number is |
Hex returns |
Null |
Null |
Empty |
Zero (0) |
Any other number |
Up to eight hexadecimal characters |
You can represent hexadecimal numbers directly by preceding numbers in the proper range with &H. For example, &H10 represents decimal 16 in hexadecimal notation.
Query examples
Expression |
Results |
SELECT Hex(2) AS Expr1 FROM ProductSales GROUP BY Hex(2); |
Returns the hexadecimal value of "2" and displays the result in column Expr1. |
SELECT quantity,Hex(quantity) AS HexValue FROM ProductSales; |
Returns the values from "quantity" along with hexadecimal value of all the data values in the column "quantity" and displays the results in the column "HexValue". |
VBA Example
Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.
This example uses the Hex function to return the hexadecimal value of a number.
Dim MyHex
MyHex = Hex(5) ' Returns 5. MyHex = Hex(10) ' Returns A. MyHex = Hex(459) ' Returns 1CB.