Carriage Return

[shamas21]

Hi All

I have a form called 'frmCustomer' and the datasource is a table called 'tblData'. The 'tblData' has a memo field and i have the memo field on my form, the memo field is called 'Notes'.

I try to populate it with pre-defined text in the VBA editor by writing the code when a button is clicked. However, when i put the vbcr in the code i expect it to populate my 'Notes' field on my form with a carriage return after the "Dear Mr Smith" but it doesnt.

Private Sub btnGo_Click()
 
     Me.Notes = "Dear Mr Smith" & vbCr & _
     "Thank you for contacting our company."
 
End Sub

The above code populates the 'Notes' feild in the folling way:
"Dear Mr SmithThank you for contacting our company."

But i want it to be the following way
"Dear Mr Smith
Thank you for contacting our company."

Can someone help please?

Thanks

 

[NigelShaw]

Hi

have you tried

vbcrlf


Regs

Nigel

 

[shamas21]

Hi

have you tried

vbcrlf


Regs

Nigel

Many Thanks

It Works Great!