Feb 20, 2005 #1 telande35 Programmer Joined Nov 27, 2004 Messages 24 Location BE Hey, I put a textbox on my report and will filled in with VBA code as follows Text4.text = "GGHGHGH" How can I put more lines in a textbox. I tried Text4.text = "First Line" & "\n" "Second line" But now luck. Nic
Hey, I put a textbox on my report and will filled in with VBA code as follows Text4.text = "GGHGHGH" How can I put more lines in a textbox. I tried Text4.text = "First Line" & "\n" "Second line" But now luck. Nic
Feb 20, 2005 #2 RoyVidar Instructor Joined Jun 16, 2000 Messages 6,606 Location NO Try one of the VBA constants: [tt]Text4.text = "First Line" & vbCrLf & "Second line"[/tt] or vbNewline, or Chr(13) & chr(10)... Roy-Vidar Upvote 0 Downvote
Try one of the VBA constants: [tt]Text4.text = "First Line" & vbCrLf & "Second line"[/tt] or vbNewline, or Chr(13) & chr(10)... Roy-Vidar
Feb 21, 2005 #3 SonOfEmidec1100 Technical User Joined Aug 12, 2001 Messages 965 Location AU You also need to set the Multiline property to true in order to get the cr/lf to wrap, rather that showing two blots. Upvote 0 Downvote
You also need to set the Multiline property to true in order to get the cr/lf to wrap, rather that showing two blots.