Adding a character return

[Blakey300]

Hi

I am using Access 2007

When I am setting a property for example creating a msgbox macro, is it
possible that when i type required message, can i add character returns to
the message?

If so how?


Regards

Dave

 

[Ken Snell MVP]

Yes. Concatenate the combination of carriage return and line feed characters
into the message string:

MsgBox("Line 1 of Message" & Chr(13) & Chr(10) & "Line 2")

 

[Tom van Stiphout]

On Sun, 8 Mar 2009 13:16:02 -0700, Blakey300

Straight from the Help file:
The MsgBox action permits you to supply a message in three sections
for the Message argument. You separate the sections with the "@"
character.

-Tom.
Microsoft Access MVP

 

[Douglas J. Steele]

Looks as though you're still using the Access 97 help file, Tom: that
capability disappeared with Access 2000, although MichKa does show how to
continue doing it in http://www.trigeminal.com/usenet/usenet015.asp

 

[Ken Snell MVP]

Or ........

MsgBox("Line 1 of Message" & VbCrLf & "Line 2")

Not in a macro, Steve. Macros have no knowledge about VB intrinsic
constants.

 

[John... Visio MVP]

Not in a macro, Steve. Macros have no knowledge about VB intrinsic
constants.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

but, but, but Ken. Stevie is an expert in Acess, Excel and Word. He must
be right.

John... Visio MVP

 

[Tom van Stiphout]

On Sun, 8 Mar 2009 17:03:34 -0400, "Douglas J. Steele"

Actually, I was using the A2007 help file and tested it in A2007
before I posted.

-Tom.
Microsoft Access MVP

 

[Ken Snell MVP]

but, but, but Ken. Stevie is an expert in Acess, Excel and Word. He must
be right.

< chuckle >