Last updated: August 26, 2026.
The IsNumeric function reports whether an expression can be evaluated as a number.
Syntax
IsNumeric(expression)| Argument | Description |
|---|---|
expression | Value to test |
Examples
IsNumeric("125.50") ' True
IsNumeric("125 items") ' False
ValidAmount: IsNumeric([AmountText])Recognition follows regional number settings and can accept formats you did not intend. Validate user input against the exact allowed format before conversion.
See Microsoft’s Access function reference for related expression functions.
