How to show month format in 'February'?

[sallyGals]

I had create a msgbox which ask user to insert record for that month. But what i want is to show the month in "February", but it just can show 2.

MsgBox ("Please insert records for month " & Month(Now))
result: Please insert record for month 2

i want this to show out:
Please insert record for month February

how to make it?
thx for kindly help.

 

[PHV]

either:
MsgBox ("Please insert records for month " & Format(Now, "mmmm")
Or:
MsgBox ("Please insert records for month " & MonthName(Month(Now))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, sorry for typos :~/
Either:
MsgBox "Please insert records for month " & Format(Now, "mmmm")
Or:
MsgBox "Please insert records for month " & MonthName(Month(Now))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sallyGals]

yeah! PHV, i had done it. It can work already.
thank you so much.