Month Year

[Bill]

Hello,
This should be easy, but I am struggling getting it right. I have a form
that I want to be able to select Month-Year (e.g., Dec-2004). I have set
up a table that contains the month-year in text format and am using a combo
box. But when I go to the form it has the date 12/1/2004. So, I can't
figure out how to format it.

Thanks.

Bill

 

[John Vinson]

Hello,
This should be easy, but I am struggling getting it right. I have a form
that I want to be able to select Month-Year (e.g., Dec-2004). I have set
up a table that contains the month-year in text format and am using a combo
box. But when I go to the form it has the date 12/1/2004. So, I can't
figure out how to format it.

An Access Date/Time field is a full date - a precise instant of time -
no matter how it's formatted.

You should be able to set the Format property of the form textbox to

mmm-yyyy

to *display* 12/1/2004 (or 12/25/2004, or any date in that December)
as Dec-2004.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps