Append memo using textbox

[anoo]

Dear Experts,
When using textbox (note) to append memo (Notes), how can I have new entries entered before existing text so that new entry appear at the top? (Line2 before Line1) - Sample attached.

Command button on click code:

Private Sub Command4_Click()
Me.Notes = Me.Notes & vbCrLf & Me.note
End Sub

is used to append values to memo field.

Also, anyone please clarify why memo field on table does not display (but not empty as form displays field text)

Thank you so much.

 

[pbaldy]

Just reverse them:

Me.Notes = Me.Note & vbCrLf & Me.Notes

In the table, it only shows the first line (which is blank in your case). You can use the down arrow to see the other lines after setting focus in the field.

 

[anoo]

Thank you so much.
You are very helpful, I really appreciate it.

 

[pbaldy]

Happy to help!