N neilmcmor Registered User. Local time Today, 11:46 Joined Aug 9, 2007 Messages 70 Oct 11, 2007 #1 I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?
I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?
boblarson Smeghead Local time Today, 03:46 Joined Jan 12, 2001 Messages 32,040 Oct 11, 2007 #2 Sure, in the control source of the text box you want the day name in: = Format([Forms]![YourFormName]![YourDateField],"dddd")
Sure, in the control source of the text box you want the day name in: = Format([Forms]![YourFormName]![YourDateField],"dddd")
N neilmcmor Registered User. Local time Today, 11:46 Joined Aug 9, 2007 Messages 70 Oct 11, 2007 #3 Thanks Bob Thanks. Perfect
boblarson Smeghead Local time Today, 03:46 Joined Jan 12, 2001 Messages 32,040 Oct 12, 2007 #4 Great! Glad to hear.
