CrLf - Alt+Enter - Memo field

[caferacer]

Hi All,

I am using -

Me.Comments = Replace(Me.Comments, Chr(10), vbCrLf)

- to remove vertical lines and replace with a CrLf when text is copied in to a memo field from Excel with Alt+Enter’s in the Excel text. On the first event procedure “double click” into the memo field, all works fine, however, if the "double click" event is carried out again (usually by mistake), it puts a vertical line back in?

I was kind of expecting a CrLf would happen if this occurred, rather than create another vertical line? No carriage return or line feed happens, just adds more vertical lines??

Any ideas

Thanks

 

[mdlueck]

Are you sure that the Access form field has multi-line values enabled? I seem to recall seeing such a property somewhere in A2007.