Is there a NEWLINE command in access

[MsPeppa]

I have a messagebox and what i want to do is create a newline inbetween information. So like my msgbox outputs fields that need to be filled in what i want it to do is have a return inbetween them. i.e


Incident Type
First Name
Last Name


etc... right now I have the code
Msg = Msg & cntl.Name ", " so it has a comma inbetween names. how do I put in a new line between names. Thanks

 

[cyberbiker]

I have had good luck with soemthing like this:
call msgbox("line 1" & chr(10) & chr(13) & "line 2" _
& chr(10) & chr(13) & "line 3", vbokonly)
The underscore character is the line continuation character for vb as you are most likely aware and is shown here to show that you can contine the msgbox arguments on more than 1 line in your text editor Terry (cyberbiker)

 

[Hargreavesk]

Try this:

Msgbox Incident Type & vbnewline & First Name & vbnewline & Last Name

Kate