Access 2000 and a lookup?

  Neill 17:54 23 Jan 03
Locked
  Neill 17:54 23 Jan 03

I have a field that I type dates in. Can I create another field or a control in a form that will look at that date and input the day of the week? The date is the day an order was cashed and I have to then look at a calendar and type the day of the week. At present I use a combo box for the day so at least I only have to type the first letter but it is the looking up as to what is the day that is very frustrating. Any ideas would be gratefully received. Thanks. Neill

  Neill 11:37 25 Jan 03

I'll answer this myself in case someone else is interested in the answer which is courtesy of another site.
Insert a Text box into a Form with it's Control Source =Format([YourDateFieldName], "dddd")
If you get #Name? go via the Code button on the toolbar to VB, select Tools, References and remove any ticks next to options with the word MISSING next to them. It should then work.

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes