CarriageReturns & LineFeed (1 Viewer)

[mike60smart]

Hi Everyone

I have the following MsgBox :-

MsgBox "An Advance has already been issued to " & [Driver] _
        & " on " & [AD] _
        & " for the amount of $" & [AA]

How can I add CrLf so that the MsgBox displays as follows:-

An Advance has already been issued to
John Smith
on 03/03/2023 for the amount of $900

Any help appreciated.

 

[MajP]

"An Advance has already been issued to: " & vbcrlf &  [Driver] & vbcrlf &  " on " & [AD]  & " for the amount of $" & [AA]

 

[mike60smart]

"An Advance has already been issued to: " & vbcrlf &  [Driver] & vbcrlf &  " on " & [AD]  & " for the amount of $" & [AA]

Many thanks just perfect