This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.


A representation of a numeric or string value that doesn't change. True, False, and Null are constants. You can use constants in expressions in tables, queries, forms, reports, and macros. In a Visual Basic module, you can use the Const statement to declare your own constants. A constant may be a string or numeric literal, another constant, or any combination that includes arithmetic or logical operators, except the Is statement and exponentiation.

Microsoft Access also provides intrinsic constants that supply fixed values for action arguments and function values (such as the values returned by the VarType function).

These constants can be viewed in the Object Browser.