Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo Field in Forms 1

Status
Not open for further replies.

e8348

Technical User
Feb 20, 2003
6
US
Is it possible to time stamp a date in a memo field?

I want this to work so that any time a person wants to add a comment to a record, a date is automatically stamped in before the comment in the memo field.

Any insight would be great.
 
No, what you want to do is create two columns. A 'timestamp' column & a memo column. Set the default value of the 'timestamp' column to Date() & do not allow users to edit existing records. Users should always create a new entry, & as such they you will automatically have the date/time of insertion. You could even log the user who entered the record using Environ("UserName")

James Goodman MCSE, MCDBA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top