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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.

Rick B said:
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



azkmc said:
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.
Click to expand...
Click to expand...
 
Check your
references.http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

--
Duane Hookom
MS Access MVP
--

azkmc said:
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.

Rick B said:
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



azkmc said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top