automatically fill in full name of weekday

[cominapart]

hello everybody. i have just joined, i am also just beginning to learn vba. i have been browsing this forum for an answer to my problem.

this is what i am trying to accomplish. on a form i have a date field named EventDay with an input mask _ _/ _ _/ _ _ _ _ .
i have been trying to use the afterupdate property of EventDate to automatically fill in EventDay with the day of the week ie Monday, Tuesday ...

(date field name = EventDate , day field name = EventDay )

trying to use

Me.EventDay = ?

? = a lot of combinations but i get nothing in the field

any help appreciated.

 

[EMP]

Me.EventDay = Format(Me.EventDate, "dddd")

 

[cominapart]

Thanks EMP, worked perfectly!