Access MonthName Function

Last updated: August 26, 2026.

The MonthName function returns the localized name of a month number.

Syntax

MonthName(month [, abbreviate])

Argument	Description
`month`	Number from 1 through 12
`abbreviate`	True to return an abbreviated name

MonthName(8)          ' August
MonthName(8, True)    ' Aug
MonthLabel: MonthName(Month([OrderDate]))

The returned name follows the system locale. Validate month numbers before calling the function.

See Microsoft’s Access function reference for related expression functions.