New line/ paragraph in memo

  • Thread starter Thread starter PS
  • Start date Start date
P

PS

Hi All,

I have a call log (memo field) which locked from being edited by user. The
purpose is to standardized the memo look and prevent user to delete existing
memo's content. It can only added by using a few unbound field.

Example

Unbound field:-
Date/ Time Log: 20/04/05 8:50am
Customer: ABC Company
Call Type: Incoming Call
Recorded by: Wilson
Call detaill : Customer call in to check order status



The require memo field (Call Log)

15/04/05 3:30PM
ABC Company / Incoming Call
Recorded by Wilson
*Log Begin*
Customer call in to place order for x items for 10
*Log End*


20/04/05 8:50AM
ABC Company / Incoming Call
Recorded by Wilson
*Log Begin*
Customer call in to check order status
*Log End*

Please asist on above VB code in order for me to fulfill above requirement.


Thank.

Patrick
 
PS said:
I have a call log (memo field) which locked from being edited by user. The
purpose is to standardized the memo look and prevent user to delete existing
memo's content. It can only added by using a few unbound field.

Example

Unbound field:-
Date/ Time Log: 20/04/05 8:50am
Customer: ABC Company
Call Type: Incoming Call
Recorded by: Wilson
Call detaill : Customer call in to check order status



The require memo field (Call Log)

15/04/05 3:30PM
ABC Company / Incoming Call
Recorded by Wilson
*Log Begin*
Customer call in to place order for x items for 10
*Log End*


20/04/05 8:50AM
ABC Company / Incoming Call
Recorded by Wilson
*Log Begin*
Customer call in to check order status
*Log End*
Click to expand...


Not sure where you want to do this, probably in the form's
BeforeUpdate event?

Me.memotextbox = Me.memotextbox & vbCrLf _
& vbCrLf _
& Format([Date/ Time Log], "d/m/yy h:nnAMPM") & vbCrLf _
& Customer & " / " & [Call Type] & vbCrLf _
& "Recorded by " & [Recorded by] & vbCrLf _
& "*Log Begin*" & vbCrLf _
& [Call detaill] & vbCrLf _
& "*Log End*" & vbCrLf
 
Back
Top