day of the week problem

[hoschi]

hi there

I got 2 text boxes: datum and day

in the datum-textbox I enter a date and I want that the second textbox (day) automatically updates itself with the Day of the Week!

I know it must be done with following code but it does not work:
=Format([datum],"dddd")

Where have I to put this code, I thought in the Property Field "Format" of the second Textbox called "day"???

I go crazy about this problem

thanx in advance

hoschi

 

[hoschi]

I forgot to say: I work with access 97!

 

[Mile-O]

Try this:

=Format(Weekday(Me.datum)+1,"dddd")

 

[Mile-O]

Sorry, in the AfterUpdate event of the first textbox.

 

[The_Doc_Man]

Is this on a form or in a table?

If it is on a form, do it in the class module. Build an event for Datum that is based on "After Update" event. Code might be so simple as

Private Sub Datum_AfterUpdate()

[Day] = Format(Weekday([Datum])+1,"dddd")

End Sub

 

[Rich]

You don't need to store this value since it can be calculated at any time, set the control source of the second textbox to =[datum], set the format for the control on the property sheet to dddd

 

[hoschi]

thanx to all, I did it like rich said and it worked fine for me!

thanx a lot

hoschi