how to separate message into two line

[newaccess]

Hi Experts,

I am learning Access 2007.
I put a message in msgbox as
MsgBox " Data Enter Error No: " & Err.Number & "; Description: " & Err.Description & "Please contact Developer"

However, system display all information at one line.

any way to put into 2 or 3 line at messagebox?

Thanks very much!
Newaccesser

 

[DCrake]

Don't think you can with Err.Descripton as you have know idea what the description is. However if you raise the error to determine the message you could manipulate it to suit your needs.

 

[newaccess]

Thanks. I got it.