Hi All,

How can I connect 2 line of strings, so my massage box will have lines.

i.e Data is missing!
check your entry



Thanks A lot,

Tom

Tom wrote:
> Hi All,
>
> How can I connect 2 line of strings, so my massage box will have
> lines.
> i.e Data is missing!
> check your entry

MsgBox "Data is Missing" & vbCrLf & "check your entry"

Actually in the specific case of a MsgBox you don't need both a Carriage Return
and a Line-Feed so these would also work...

MsgBox "Data is Missing" & vbCr & "check your entry"
MsgBox "Data is Missing" & vbLf & "check your entry"

....but when doing similar things in other contexts you do need both so I tend to
always use vbCrLf. It will not cause two lines in a MsgBox so is harmless.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thank you Rick, working good
"Rick Brandt" <(E-Mail Removed)> wrote in message
news:9yG9g.5982$(E-Mail Removed)...
> Tom wrote:
>> Hi All,
>>
>> How can I connect 2 line of strings, so my massage box will have
>> lines.
>> i.e Data is missing!
>> check your entry
>
> MsgBox "Data is Missing" & vbCrLf & "check your entry"
>
> Actually in the specific case of a MsgBox you don't need both a Carriage
> Return and a Line-Feed so these would also work...
>
> MsgBox "Data is Missing" & vbCr & "check your entry"
> MsgBox "Data is Missing" & vbLf & "check your entry"
>
> ...but when doing similar things in other contexts you do need both so I
> tend to always use vbCrLf. It will not cause two lines in a MsgBox so is
> harmless.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>