add a date and a blank line in a memo field

  • Thread starter Thread starter Hilva
  • Start date Start date
H

Hilva

I am using Access 2000. I have a form with a memo field.
Is it possible to have a computer to automatically add a
current date and a blank line everytime when the user try
to enter a new info. So, it will save the user a couple
keystroke. Any idea or website where I can find my answer?

Thank you so much for your help.
 
I am using Access 2000. I have a form with a memo field.
Is it possible to have a computer to automatically add a
current date and a blank line everytime when the user try
to enter a new info. So, it will save the user a couple
keystroke. Any idea or website where I can find my answer?

Thank you so much for your help.
Click to expand...

Where do you want the new date and line entered?
After the new data has just been entered?

Code the AfterUpdate event of the Memo Field Control:
Me![MemoField] = Me![MemoField] & Date & vbNewLine

In front of the new Data to be entered?
Code the Memo Field Enter event:
Me![MemoField] = Me![MemoField]

Note, You may want to add a space before or after the date to make the
new data entry easier:
& vbNewLine & Date & " "
or
& " " & Date & vbNewLine
 
Fred, thank you so much.
-----Original Message-----
I am using Access 2000. I have a form with a memo field.
Is it possible to have a computer to automatically add a
current date and a blank line everytime when the user try
to enter a new info. So, it will save the user a couple
keystroke. Any idea or website where I can find my answer?

Thank you so much for your help.
Click to expand...

Where do you want the new date and line entered?
After the new data has just been entered?

Code the AfterUpdate event of the Memo Field Control:
Me![MemoField] = Me![MemoField] & Date & vbNewLine

In front of the new Data to be entered?
Code the Memo Field Enter event:
Me![MemoField] = Me![MemoField]

Note, You may want to add a space before or after the date to make the
new data entry easier:
& vbNewLine & Date & " "
or
& " " & Date & vbNewLine
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Click to expand...
 
Back
Top