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.