Date as format mm/yy

Is it possible to set a date field in a table/form to display only mm/yy. In
Word 2003 I could display a date field as mm/yy, is it possible also in
Access 2007?

Sure. Set the Format property to mm/yy, same as in Word.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"???" wrote in message
...
Is it possible to set a date field in a table/form to display only mm/yy.
In
Word 2003 I could display a date field as mm/yy, is it possible also in
Access 2007?

Open form in design view, click on the text box, double click, scroll down
and select Properties.
Click on Data tab and in the Format property type mm\/yy and save.

--
Build a little, test a little.


"משה" wrote:

Is it possible to set a date field in a table/form to display only mm/yy. In
Word 2003 I could display a date field as mm/yy, is it possible also in
Access 2007?

That's what I thought and tried but it doesn't work

"KARL DEWEY" wrote:

Open form in design view, click on the text box, double click, scroll down
and select Properties.
Click on Data tab and in the Format property type mm\/yy and save.

--
Build a little, test a little.


"משה" wrote:

Is it possible to set a date field in a table/form to display only mm/yy. In
Word 2003 I could display a date field as mm/yy, is it possible also in
Access 2007?

On Tue, 8 Sep 2009 10:45:03 -0700, ??? wrote:

That's what I thought and tried but it doesn't work

What "doesn't work"? Displays the wrong date? displays a different format?
gives an error message? sets your computer on fire?

What did you use as the Format property of the textbox, and what do you see in
the textbox?

Possible additional issue: is this in fact a Date/Time field, or is it a Text
field containing data that looks like a date?
--

John W. Vinson [MVP]

Also,

Because you have put that format on it does NOT mean that is what is
being stored in the field.

AND you cannot enter data into that field on that form using that
field. A date field MUST have a month and a day and a year. One way
or the other that is what is required to enter or change information
in that field.

Ron

In the display I see mm/yy and cannot enter any data [if it has set my
computer on fire I wouldn't have got the reply - lol]
The text box I am using is using a date/time property

"John W. Vinson" wrote:

On Tue, 8 Sep 2009 10:45:03 -0700, ??? wrote:

That's what I thought and tried but it doesn't work

What "doesn't work"? Displays the wrong date? displays a different format?
gives an error message? sets your computer on fire?

What did you use as the Format property of the textbox, and what do you see in
the textbox?

Possible additional issue: is this in fact a Date/Time field, or is it a Text
field containing data that looks like a date?
--

John W. Vinson [MVP]

Despite the fact that it only displays mm/yy, it's still a date, and you
must enter a proper date in the field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"???" wrote in message
...
In the display I see mm/yy and cannot enter any data [if it has set my
computer on fire I wouldn't have got the reply - lol]
The text box I am using is using a date/time property

"John W. Vinson" wrote:

On Tue, 8 Sep 2009 10:45:03 -0700, ???
wrote:

That's what I thought and tried but it doesn't work

What "doesn't work"? Displays the wrong date? displays a different
format?
gives an error message? sets your computer on fire?

What did you use as the Format property of the textbox, and what do you
see in
the textbox?

Possible additional issue: is this in fact a Date/Time field, or is it a
Text
field containing data that looks like a date?
--

John W. Vinson [MVP]

On Tue, 8 Sep 2009 13:54:47 -0700, ??? wrote:

In the display I see mm/yy and cannot enter any data [if it has set my
computer on fire I wouldn't have got the reply - lol]
The text box I am using is using a date/time property


As Ron and Douglas say, if the field is a Date/Time field then you must enter
a complete date (regardless of the format). A Date/Time is stored internally
as a double float number, a count of days and fractions of a day (times) since
midnight, December 30, 1899; as such it corresponds to a precise instant of
time. September 2009 is not a precise instant of time! You can STORE
#09/01/2009 00:00:00# or #09/14/2009 11:31:28# in a DateTime field, and it
will display as 09/09 if you use a Format of mm/yy; but when you edit the
field you must enter a full date.

If you only want the month and year and don't need a real date, consider
storing two Number fields and concatenating them for display, rather than
stuffing non-date data into a date field.
--

John W. Vinson [MVP]

Ron2006 wrote in

m:

AND you cannot enter data into that field on that form using that
field. A date field MUST have a month and a day and a year. One
way or the other that is what is required to enter or change
information in that field.

Eh? Of course you can enter month/year and leave out the day (the
first day of the month will be supplied). You can also enter
month/day and leave out the year (the current year will be
supplied).

A mm/yyyy format combined with 00/0000 input mask pretty much takes
care of it. With or without a date mask, the control will display
the full date when it has the focus if the value has already been
filled out. So far as I know, there's no way to work around that
(and it's probably the desired behavior in most cases, though it's
not helpful with a credit card expiration date, for instance).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/