I can't use the format$ or any formula's that use format function

[Guest]

I have been using =Format$([Date],"mmmm yyyy"), to show a date format in
Access 2000. Access isn't recognizing Format$ anymore. I tried using the
Date and Time funtion from the tool bar, but Access doesn't recognize the
Format part of the date formula.

 

[Rick B]

I have never used Format$, but I have used Format. Not sure what the "$"
does.

Are you actually using a field called "date"? That is a reserved word and
probably should not be used as a field name.

 

[Guest]

It worked that way for a while, I can't even use the one that you select out
of the toolbar, Insert/Date and Time. I can do the date in a text box and
select the formatted dates there, but I can't use the word format as a
function.

I have never used Format$, but I have used Format. Not sure what the "$"
does.

Are you actually using a field called "date"? That is a reserved word and
probably should not be used as a field name.

--
Rick B

I have been using =Format$([Date],"mmmm yyyy"), to show a date format in
Access 2000. Access isn't recognizing Format$ anymore. I tried using the
Date and Time funtion from the tool bar, but Access doesn't recognize the
Format part of the date formula.

 

[Duane Hookom]

Check your
references.http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

--
Duane Hookom
MS Access MVP
--

It worked that way for a while, I can't even use the one that you select
out
of the toolbar, Insert/Date and Time. I can do the date in a text box and
select the formatted dates there, but I can't use the word format as a
function.

I have never used Format$, but I have used Format. Not sure what the "$"
does.

Are you actually using a field called "date"? That is a reserved word
and
probably should not be used as a field name.

--
Rick B

I have been using =Format$([Date],"mmmm yyyy"), to show a date format
in
Access 2000. Access isn't recognizing Format$ anymore. I tried using
the
Date and Time funtion from the tool bar, but Access doesn't recognize
the
Format part of the date formula.