Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Thanked 0 Times in 0 Posts

    Automatically return Day of week (2000)

    i have a form where someone enters the date. I would like the form to automatically enter the Day of the week into a field in the same table upon which the form is based, and display it in the form as soon as the date is entered.

    Would be grateful for advice how to achieve. I know where to find On Event procedures in form design, if that is what is required but beyond that, would appreciate help. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Automatically return Day of week (2000)

    Do you store the date itself in the table? If so, you shouldn't store the day of the week in the table - it is derived information, so storing it is superfluous. Instead, you can place a text box on the form bound to the date field, and set its Format property to ddd or dddd, depending on whether you want to see Mon, Tue etc., or Monday, Tuesday etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts