Line Feed/Carriage Return in Memo Field

[avisram]

Hi there,

I'm trying to insert a carriage return or linefeed in a memo field via a macro using the SetValue action. The expression that I am currently using is:

[Forms]![HPD:HelpDesk]![Work Log] & Chr(10) & Now() & " " & CurrentUser() & ">>" & [Forms]![HPD:HelpDesk]![Temp Work Log]

In the above expression the Chr(10) is supposed to enter a linefeed, however, it is entering a symbol of a square instead. I have tried Chr(13) with the same results.

Any assistance is greatly appreciated.

Amyn Visram

 

[Spellman]

try using the constant vblf or vbcr to see if that helps.

 

[abig99]

or even using vbcrlf which does both line feed and carraige return at the same time.

 

[avisram]

Spellman/abig99:

Thanks for the help. That worked great! Only I couldn't use the vbCrLf constant directly in the macro SetValue expression. So instead I created a function and used the RunCode action from the macro.

Thanks again.

Amyn Visram