displaying a date

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Simple question - is there a way to display only the date
and year of a text box that contains a date field?

Also, is there a way to allow this?

if you type in september 2003 the date would default to
1st september 2003.

I'd appreciate any assistance. Thank you in advance.
 
You can *display* the month and year by setting the Format property of the
text box to
mmmm yyyy
However, when the focus moves to the date box, it will set up for data
entry.

If you type
september 2003
into a text box, Access does interpret it as 1 September 2003.
 
Mark,
Remarks interspersed below.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Mark said:
Simple question - is there a way to display only the date
and year of a text box that contains a date field?
Click to expand...

I assume you mean the day and the year.
Set the Format property to the control to
d/yyyy
to display today's date as 17/2003.
Also, is there a way to allow this?

if you type in september 2003 the date would default to
1st september 2003.
Click to expand...

If you do not use an Input Mask, just enter the month and year in an
unambiguous date format:
10/2003
Oct 2003
October 2003

Access will set the date to the first of the month.

Enter the date as 10/21 and Access will assume the current year 10/21/2003.
However, if the date is ambiguous, i.e. 10/03 (using 2 digit for 2003)
Access will assume the 3rd day of October, not year 2003.
 
Back
Top