Day of Week Entered Automatically

[Earl Anderson]

Reading Google archives, I found a quick and simple solution from Allen
Browne of having a "Day of Week" textbox automatically filled from a
separate date field textbox. I put the function { =Format([fldNCDATE],
"dddd") } into the Control Source of the Day of the Week textbox, removing
the previous 'lookup values' (Sunday - Saturday) that I had in the Control
Source. When I tried it, 'Nothing' happened. When I entered a date into
[fldNCDATE] textbox and moved off of that control, the [txtDayofWeek]
remained blank.
I then removed the previous Row Source and Source Type data as it pertained
to the 'lookup values' I had use before with the previous (no longer
pertinent) properties of the [txtDayofWeek] textbox and still, 'Nothing'.
Previously, I at least had a lookup with all seven (7) days of the week
listed, but because I removed the former properties, those 'days of the
week' were no longer available and neither was the expected result of the
inserted function.

What did I do to screw up this simple function?

Getting me on track is gratefully accepted...
Earl Anderson

[Allen Browne]

If you have a field or control named, "fldNCDATE", all you need is another
*text box* with these proeprties:
Control Source =[fldNCDate]
Format dddd

Not sure what you actually have, as a text box would not have Row Source or
Source Type properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Earl Anderson" <is*****@rcn.com> wrote in message
news:bp**********@bob.news.rcn.net...

Reading Google archives, I found a quick and simple solution from Allen
Browne of having a "Day of Week" textbox automatically filled from a
separate date field textbox. I put the function { =Format([fldNCDATE],
"dddd") } into the Control Source of the Day of the Week textbox, removing
the previous 'lookup values' (Sunday - Saturday) that I had in the Control
Source. When I tried it, 'Nothing' happened. When I entered a date into
[fldNCDATE] textbox and moved off of that control, the [txtDayofWeek]
remained blank.
I then removed the previous Row Source and Source Type data as it pertained to the 'lookup values' I had use before with the previous (no longer
pertinent) properties of the [txtDayofWeek] textbox and still, 'Nothing'.
Previously, I at least had a lookup with all seven (7) days of the week
listed, but because I removed the former properties, those 'days of the
week' were no longer available and neither was the expected result of the
inserted function.

What did I do to screw up this simple function?

Getting me on track is gratefully accepted...
Earl Anderson

[Earl Anderson]

Thanks Allen.
It worked perfectly after you pointed out that I had a combo box (Row Source
and Row Source Type) as my Day of the Week control and not a textbox.
Earl

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

If you have a field or control named, "fldNCDATE", all you need is another
*text box* with these proeprties:
Control Source =[fldNCDate]
Format dddd

Not sure what you actually have, as a text box would not have Row Source or Source Type properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Earl Anderson" <is*****@rcn.com> wrote in message
news:bp**********@bob.news.rcn.net...

Reading Google archives, I found a quick and simple solution from Allen
Browne of having a "Day of Week" textbox automatically filled from a
separate date field textbox. I put the function { =Format([fldNCDATE],
"dddd") } into the Control Source of the Day of the Week textbox, removing the previous 'lookup values' (Sunday - Saturday) that I had in the Control Source. When I tried it, 'Nothing' happened. When I entered a date into
[fldNCDATE] textbox and moved off of that control, the [txtDayofWeek]
remained blank.
I then removed the previous Row Source and Source Type data as it

pertained

to the 'lookup values' I had use before with the previous (no longer
pertinent) properties of the [txtDayofWeek] textbox and still, 'Nothing'. Previously, I at least had a lookup with all seven (7) days of the week
listed, but because I removed the former properties, those 'days of the
week' were no longer available and neither was the expected result of the inserted function.

What did I do to screw up this simple function?

Getting me on track is gratefully accepted...
Earl Anderson