Append to top of a memo field

S

Song Su

Access 2003

Is it possible to let user type something on the form, click a button, the
content of user's typing plus current date and network login ID (I know how
to get this ID) append on TOP of a memo field? The reason is I don't want
user to edit the memo's content directly.

I know Access 2007 memo can be append only but my users use Access 2003.
 
K

Klatuu

Assume you have a text box where the user types named txtTypeIn and a text
box bound to the memo field named txtMyMemo
This will put the value of txtTypeIn at the beginning of the memo field
followed by a line field:

Me.txtMyMemo = Me.txtTypeIn & vbNewLine & Me.txtMyMemo
 
S

Song Su

Great! Thanks a lot. It works!

Klatuu said:
Assume you have a text box where the user types named txtTypeIn and a text
box bound to the memo field named txtMyMemo
This will put the value of txtTypeIn at the beginning of the memo field
followed by a line field:

Me.txtMyMemo = Me.txtTypeIn & vbNewLine & Me.txtMyMemo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top