date problem

[mmmsonu]

i am wanted to put blank date into access
database.How to update date field with an
empty text box.Shuld i first covert text box text
to date data type.I am using vb 6.0,ado.

Type within a text box =NOW()

This shall display a static date - Do you want it to be constantly updated??

[Asaf_99]

Originally posted by rlculver
This shall display a static date - Do you want it to be constantly updated?? [/B]

If so then put a timer and a textbox:

Private Sub Form_Load()
Timer1.Interval = 100
End Sub

Private Sub Timer1_Timer()
Text1.Text = Now
End Sub

By the way there are some more time functions:
Text1.Text = Time
Text1.Text = Date
Text1.Text = Now
Text1.Text = Hour(Time)
Text1.Text = Minute(Time)
Text1.Text = Second(Time)
Text1.Text = Day(Time)
Text1.Text = Month(Date)
Text1.Text = Tear(Date)
Text1.Text = Weekday(Date)

Hope I helped...
,Asaf Sagi