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" <AllenBrowne@SeeSig.Invalid> wrote in message
news:3fb44ae1$0$1729$5a62ac22@freenews.iinet.net.a u...[color=blue]
> 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[/color]
or[color=blue]
> 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" <isobadd@rcn.com> wrote in message
> news:bp1e5d$ltg$1@bob.news.rcn.net...[color=green]
> > 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,[/color][/color]
removing[color=blue][color=green]
> > the previous 'lookup values' (Sunday - Saturday) that I had in the[/color][/color]
Control[color=blue][color=green]
> > 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[/color]
> pertained[color=green]
> > to the 'lookup values' I had use before with the previous (no longer
> > pertinent) properties of the [txtDayofWeek] textbox and still,[/color][/color]
'Nothing'.[color=blue][color=green]
> > 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[/color][/color]
the[color=blue][color=green]
> > inserted function.
> >
> > What did I do to screw up this simple function?
> >
> > Getting me on track is gratefully accepted...
> > Earl Anderson[/color]
>
>[/color]
