return the day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

esparzaone - 10 May 2005 16:42 GMT

How do I type in the date i.e. 5/10/2005 in one field and in the other field
have it autofill the day Tuesday. I looked at other post and found this
Format (date(),"dddd")
I tried entering this in the format section of the second box and it didn't
work. 1 more questions it suggested to go to online help under format
function - where is this?

Thanks in advanced!
Zenis

Reply to this Message

Rick B - 10 May 2005 16:53 GMT

In a new UNBOUND TEXT field, enter...

=Format ([?????],"dddd")

Replace ????? with the prompt or field name that represents your entered
date.

In your original post, your formula (if entered in the right spot) would
have simply returned the day for the CURRENT date, not the entered date.

Note that this is put in an UNBOUND field because you would not store this
in your table. That would be redundant since you are already storing the
DATE and can pull out the day in your queries, forms, or reports using an
unbound field as demonstrated in the first paragraph above.

Signature

Rick B

> How do I type in the date i.e. 5/10/2005 in one field and in the other field
> have it autofill the day Tuesday. I looked at other post and found this
[quoted text clipped - 5 lines]
> Thanks in advanced!
> Zenis

Reply to this Message

Alex White MCDBA MCSE - 10 May 2005 16:57 GMT

use the on change event of the box you are typing into to set the day of
week

e.g.

within the event

me.txtDayOfWeek.value = format(now(),"dddd")

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

> How do I type in the date i.e. 5/10/2005 in one field and in the other
> field
[quoted text clipped - 7 lines]
> Thanks in advanced!
> Zenis

Reply to this Message

BruceM - 10 May 2005 17:08 GMT

The problem may be that there is nothing to format. The format function can
format a value, but it can't create one. If the first text box is txtDate1
and the second txtDayOfWeek, you could put this into the After Update event
of txtDate1:
Me.txtDayOfWeek = Format(Me.txtDate1,"dddd")
You could put the code in any number of other places, so explain the
specific circumstances if you need another approach.
Remember that txtDayOfWeek is unbound.

Reply to this Message