Re: Date format to display month name



Very close, just put full quotes around the mmmm bit and don't call it Month
(a Reserved word) except in your labels and captions

Mnth:Format([docdate],"mmmm")

Evi
"reji" <u43819@uwe> wrote in message news:84aef0352e2e1@xxxxxx
I am using Access 2000. In a query I have a field called docdate. I wish
to
display this field's month name in same query as January, February, and
so
on . So I typed the command Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined function "
Format " in expression.

Please help me.


Regards,


Reji



.



Relevant Pages

  • Re: Sharing Digital Image Suite Library
    ... Image Suite Library with captions and labels and now would like to ... It appears the labels and captions from the Library ... how to share these pictures along with the meta data I have included ...
    (microsoft.public.windowsxp.photos)
  • Re: Changeable form labels
    ... > able to change the labels on the form for those 5 fields. ... enter the starting names of the labels in the LabelName ... and their starting captions in the CaptionText field. ... Dim strNewLabel As String ...
    (microsoft.public.access.forms)
  • Re: Dlookup and update not working correctly
    ... resources you would recommend for figuring out this kind of syntax? ... You need to put the variable outside the quotes. ... reserved word and will be confused with the VBA function. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clearing the captions of labels
    ... >> When a viewing form has reached the end of a set of records (ie, ... > captions, there gone unless you have some ... > the labels are back anyway. ... > Dim c As Control ...
    (microsoft.public.access.formscoding)
  • Cant change subform on a report
    ... I'm trying to produce a report containing two subforms. ... same forms are used for data input, and change their labels captions ... The problem is that subforms on a report are not changing their labels ...
    (microsoft.public.access.formscoding)