Prev: banking
Next: Use DCount to specify data with two criteria in a text box
From: Chet in Colorado on 27 Jun 2008 19:18
How do I get July, not 7 for month heading in calendar?
From: Duane Hookom on 27 Jun 2008 21:09
Depending on your version of Access, you could probably use the MonthName()
function. You could also use an expression like:
=Format(DateSerial(2000,[Month Field],1),"mmmm")

--
Duane Hookom
Microsoft Access MVP


"Chet in Colorado" wrote:

> How do I get July, not 7 for month heading in calendar?
From: ruralguy via AccessMonster.com on 28 Jun 2008 20:44
MonthName(7) unless you are talking about the ActiveX calendar control in
which case you should do one of your own or use one of these:
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html


Chet in Colorado wrote:
>How do I get July, not 7 for month heading in calendar?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: banking
Next: Use DCount to specify data with two criteria in a text box