Adding date / time

[busted]

Hi all..

Well hope someone can help me out here.

I have created a database application that uses SQL.
Next thing that has been bugging me for a while now is
how to add the system date and time in to a textbox.

I've managed to succeed in this, but the next thing happend.

IT DELETED THE DATA I HAD IN THE TEXTBOX! :(

What I want to establish is, that if I retreive the record
and want to edit the text in the "textbox", to add the systems date and time at the last line available.

Is there someone, anyone out there who can help me?

Greetz.

[Bigley]

I think what you are trying to do here is

text1 = text1 & date()

Hope this helps

[busted]

Hi there,

Thx for your post. :)
but I now have this stupide thing. *LOL*

I did this like above, but if i add the next to the code
chr$(10) + chr$(13) it returns two lines next to eachother instead of placing a return.

do you have any idea how this comes?

Greetz

[Arbiter]

Use

text1 = text1 & vbCRLF

That should do the trick...

[busted]

He both of you..
thanks for the help here.

Hope you can help me out in the near future if i ever get to have an new problem.. :)

tnx again..

greetz