New line in a message text

[serransa]

I have an embedded macro that send and email to the assignee of an action item. I would like to enter a new line in the message text. I would like for "*Due Date" to be in a new line. How do I do that? I have tried vbNewLine, vbCrLf, and & Chr(13) & Chr(10) &. Nothing seems to work


Here's my code:
=IIf([Form].[Description].[TextFormat]=1,PlainText("Action Item Description: " & [Description] & " " & "*Due Date: " & [Due Date]),[Description] & " Due Date: " & [Due Date])

I would like the body of the message to look as follows:

Action Item Description: Action item need to be worked
*Due Date: 2012-06-04

Please advice/help

 

[AccessMSSQL]

Try using <BR\>

 

[serransa]

Thanks for your reply.
How would I add <br\> the the following code so it breaks at "*Due Date". What would be the correct syntax?

=IIf([Form].[Description].[TextFormat]=1,PlainText("Action Item Description: " & [Description] & " " & "*Due Date: " & [Due Date]),[Description] & " Due Date: " & [Due Date])

I tried several way and it continues to say it can't parse the expression.

Thanks for the help

 

[AccessMSSQL]

Correction:
Just put <BR> right after [Description] within the double-quote

=IIf([Form].[Description].[TextFormat]=1,PlainText("Action Item Description[COLOR=red]:[/COLOR] " & [Description] [B]& "[COLOR=red]<BR>[/COLOR]" &[/B] "*Due Date: " & [Due Date]),[Description] & " Due Date: " & [Due Date])

 

[serransa]

Thanks for the help.

 

[BlindPro]

yes try using <br>