Month Yr Format

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

Guest

Hello. I have a Month Yr field in a table. I understand how to format the
field in a query, btu how can I format this field in a table, when this field
also appears in a form. Example 28 Jan 07, should appear as January 07.
Thanks..Steven
 
Sydrae,
I'm not sure what you mean by a Month Year field in your table. You must mean a
Date/Time type.
Given a value of 28 Jan 07 stored in that field... then, on the form, set the Format
for the date control for...
mmmm yy
That will display on the form as January 07

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Correct. I meant date/time type. I formatted a date/time value in a query
using "mmmm yy" to format a field. I assumed the form would only accept the
loaded date formats. Thanks for the help. It worked! Have a good week
 
Back
Top