Extract a 3 digit day from a date field into its own field.
in [Form]
|
Prev: Populate Form and subForms based on the user's selection from a combo box
Next: Tab control disappears.
From: George on 18 Jan 2010 19:57 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 18 Jan 2010 21:00 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 18 Jan 2010 21:15 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 18 Jan 2010 22:29
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 |