Next line

[accessman2]

In VB,

I want to display the message like this

Format Changed
Please go back.

Msgbox "Format Changed /n Please go back"

it doesn't work. I want to use one message box only to show two line sentences.
Thanks.

 

[edtab]

Try this:

Msgbox "Format Changed " & vbCrLf & "Please go back", vbExclamation

I'm going by memory and have not tested it, but I think it will work.
If it doesn't let me know.

 

[ghudson]

Search (now there is a novel idea ;-) the Access help files for the "Miscellaneous Constants".

 

[accessman2]

How can I make double line, or many line?


Is it just using VBCrlf?

double line: vbcrlf, vbcrlf
.....

 

[ghudson]

AccessBoy,

Instead of asking us... Why don't you try it and see what happens! You just might learn something on your own!

The Search function on this forum really does work. Maybe you could try using the Search function before hitting that new post button and wasting our time.

Hopefully the regulars on this forum will recognize your useless questions and ignore your posts!

 

[modest]

Hudson, down boy. He's a new guy that doesn't yet know the ways and there really is no reason to jump on him so quickly.

AccessBoy, VBA is a separate language from C/C++. You cannot use /n within a string. Although hudson does not have to post, you should take some of his advice. I believe that almost all (if not all) of the basic intro-level questions have been answered through this forum. The answer to these questions are stored in the forum's database, which you may search at your own leisure.
As a plus to that, we're moving more towards answering more technical/advanced questions. This is good because it allows the pool of access-knowledge people to focus on the questions you might one day have.

Anyhow, to answer your original post. In the VBA editor, goto the Help Menu and search for line returns.

VBA provides many different ways to perform a newline:
vbNewLine -newline
vbCr -carriage return
vbCrLf -carriage return line feed
vbLf -line feed

each of these provide different ways to produce a line break. However, if you want to generate multiple breaks, you will have to put them in your code twice, or you will need to generate a loop to call it more than once. In certain cases programmers have developed functions to do this.

 

[ghudson]

Hudson, down boy. He's a new guy that doesn't yet know the ways and there really is no reason to jump on him so quickly.

I disagree.

Check out all the intellectual questions AccessBoy has posted and you will see where my comments are coming from. Lame threads AccessBoy has started

I have repeatedly asked AccessBoy to search the forum before posting his questions and yet he refuses to help himself before starting a new post on a subject that usually has been discussed and answered before.

 

[Bat17]

Out of 66 posts that he has made so far, 49 have been new threads, which means that with at least 32 of the questions he has asked he has not even had the curtesy to reply to the people who have tried to help!

Peter

 

[ghudson]

Ah the memories. It has been just over three years since my first post in this forum and I have only started 83 threads out of my 3,798 postings [as of today]. Funny that it took about three weeks before my first posting finally received a response. Hopefully I have thanked most of those who helped to answer the threads I have started along my journey with Access programming.

 

[MsLady]

I disagree.

Check out all the intellectual questions AccessBoy has posted and you will see where my comments are coming from. Lame threads AccessBoy has started

I have repeatedly asked AccessBoy to search the forum before posting his questions and yet he refuses to help himself before starting a new post on a subject that usually has been discussed and answered before.

bwaahahahahahahahahaa....LMAOOO

okay...I was looking for a way to do carriage return on my msgbox, did a search and that's how i came across this thread.
I got the answer from here...but this post is F--ing funnyy...

ghudson...ur cold..lmao

You are right, The search priviledge is a very lovely thing about this forum. It's very helpful and saves you lots of time, waiting for people to reply to your post. And you also learn a thing or two from other people's problems.