New Line in label, Chr(13) not working. 2

[grande]

In the past, I have made a newline on a MsgBox by using Chr(13). Now I'm trying to put a new line onto a label, and all I'm getting is a box, and the text continues along the same line.

Am I doing something wrong, or is there a way around this?

-------------------------
Just call me Captain Awesome.

 

[LNBruno]

I've always used the chr(10) & chr(13) for a new line + carriage return (actually, I prefer VBA's vbcrlf).

< M!ke >

 

[BobStubbs]

A new line in a label is created by two characters, ASC 13 and ASC 10. Try creating a label on a test form, called lblTest1. Make this tall enough to hold two lines of text.

Now create a command button on the form, and write this code into its On_Click event:

Me.lblTest1.Caption = "Line One" & Chr$(13) & Chr$(10) & "Line Two"

Access VBA has a built in 'New Line' constant, containing these two characters, which you can use for convenience:

Me.lblTest1.Caption = "Line One" & vbNewLine & "Line Two"

I hope this is useful.

Bob Stubbs

 

[VBslammer]

You'll probably have to use [tt]vbCrLf or vbNewLine[/tt] to make it format properly.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[grande]

Yeah, I ended up using vbCrLf. Thanks guys!

-------------------------
Just call me Captain Awesome.