Using The Enter Key In A Memo Box

[crow]

In my database, there is a section where I can enter information in a memo form. No problem here. What I would like to do, is add comments to the original comment but using the enter key or somehow be able to put a space between comments to ease the reading of the comments. Also wondering if there might be a way to auto insert a date and time directly into the comments area each time an addition is made? If anyone could help with one or both of these questions, it would be greatly appreciated!

 

[GabrielR]

In my database, there is a section where I can enter information in a memo form. No problem here. What I would like to do, is add comments to the original comment but using the enter key or somehow be able to put a space between comments to ease the reading of the comments. Also wondering if there might be a way to auto insert a date and time directly into the comments area each time an addition is made? If anyone could help with one or both of these questions, it would be greatly appreciated!

I would set up another table for Comments with a One to many relationship between the table and the original Comment.

 

[neileg]

I agree with Gabriel. It's the best way to go.

However you could concatenate the existing memo contents with the new contents and include today's date in an append query.