By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,605 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,605 IT Pros & Developers. It's quick & easy.

display only month not day or year

100+
P: 107
hello,
I am having trouble displaying just the month in access report field.
I have tried "mmmm" and the month name displays - but also does the mmmm- I know I can write month(fieldname) - but this gives me number of month.

I would like to be able write something in the properties of field - in format line-

thank you
Jun 4 '09 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
In Properties - Format simply mmmm without the quotation marks. In VBA code you could use

Format(YourField, "mmmm")

Linq ;0)>
Jun 4 '09 #2

100+
P: 107
Thank you that works
Jun 4 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.