Textbox Code for Date Format

[FerryMary]

Pretty sure it's something silly on my part.

form contain combobox 'Date'
(It looks up dates from specified dates within payroll timeframes)
No-Control text box placed next to combo box to have Day of Week appear to
keep people on right day. (I don't like the calendar idea, because I need to
keep people in the correct payroll date range and other items.)

For text box, from property window / data tab / control source I've entered

=Formate([Date],"dddd") expecting the day of the week to appear on focus.
Field populates fine but shows wrong day of the week.

Actual Date in [Date] combo box is 1/23/10.
Text box is returning 'Sunday'.

Am using Access 2003
Op System Windows XP

Thanks so much.

 

[Al Campagna]

FerryMary,
First... don't name a control [Date]. It's a reserved word in Access.
Try PayrollDate, or PayDate, etc...
Still have a problem? Post back on this thread...
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."