View Full Version : DATE to Day of Week


Pasadena
01-30-2001, 08:00 PM
Does anyone know how the Day of week can automatically be filled by putting in the date. I have date and day of week on a form, and it would be great to have the day of week filled in.

Rich
01-30-2001, 10:48 PM
Set the day textbox control source to =[YourDateTextBox], set format to dddd You don't need to store the day in the table since you already have the date.

Pasadena
01-31-2001, 01:46 AM
Rich
It did work and now I'm getting #Name?

Rich
01-31-2001, 03:50 AM
Ok delete the original day textbox add a new one from the toolbox ahd set control source as before.
HTH

Pasadena
01-31-2001, 07:44 PM
That worked!! Thank you Rich