Month name not displayed on form

[graveyard]

hi people, I have a pro with a form that is supposed to show the month name when user query data by inputting month number (1= January, 6 = June etc).

i set the control source of the text box (that is supposed to display the month name) as =Format([Forms]![Cover]![MonthNum],"mmm") where form!cover!monthnum is the box where user punch in the month number

but no matter what number is keyed, it always come out as Jan - pls see attachment which shld give a clearer picture. When "6" is entered, i expect to see the header to reflect "June"

Pls let me know what has gone wrong. Thanks!

 

[John Big Booty]

Try the MonthName() function that should return the result you are after.

 

[graveyard]

Try the MonthName() function that should return the result you are after.

Hi John - thanks! Works totally!!

 

[graveyard]

thanks Bob! Will take note of the format requirement - i dont have the full date here. Nevertheless, monthnumber advised by john fixed it.