Insert date & time in field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a project log field. When the user clicks the memo field, I want the date and time inserted as well as placing the curser in the beginning of the field. Is this do-able? This way there is always a date on the log of conversation or stats recorded.
 
You could use some event (GotFocus?) to add the date to the start of the
field and position the cursor at the beginning like this:
Me.Memo = Date & Me.Memo
Me.Memo.SelStart = 0

However, it may be better to create a related table of notes, with a
date/time field for the note. This would make it very easy to ensure the
date is entered, sort the notes or filter them, etc. Not to mention the
problem of unnecessary dates being added just because someone clicked on the
text box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Linda Salazar said:
This is a project log field. When the user clicks the memo field, I want
Click to expand...
the date and time inserted as well as placing the curser in the beginning of
the field. Is this do-able? This way there is always a date on the log of
conversation or stats recorded.
 
Back
Top