From: George on
I created a Data Entry Form which allows a person to enter a date into one of
the fields. The next field requires a 3 digit day entry (Example---Mon, Tue,
Wed, Thu Fri, Sat, Sun). I would like to automate this and have the day
inserted after the date is supplied in the previous field.
Thanks
George
From: Linq Adams via AccessMonster.com on
Is this a Single View Form?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1

From: Linq Adams via AccessMonster.com on
Regardless of the form view, since this is a calculated value it should be
placed in an unbound field, i.e. it shouldn't be stored in a table.

In the Control Source for the DayField Textbox use this

=IIF(Not IsNull([DateField]),Format([DateField], "ddd"), Null)

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1

From: Clifford Bass via AccessMonster.com on
Hi George,

Of course you could just format the date field to display the day in the
three-letter format. On entry into the field, it will revert to the locale
format. So if you set the format to "ddd mm/dd/yyyy" it will show Fri
01/01/2010 when not in the field. On entry to the field it will show
1/1/2010.

Clifford Bass

George wrote:
>I created a Data Entry Form which allows a person to enter a date into one of
>the fields. The next field requires a 3 digit day entry (Example---Mon, Tue,
>Wed, Thu Fri, Sat, Sun). I would like to automate this and have the day
>inserted after the date is supplied in the previous field.
>Thanks
>George

--
Message posted via http://www.accessmonster.com