Feb 20, 2005 #1 telande35 Programmer Nov 27, 2004 24 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 Jun 16, 2000 6,606 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 Aug 12, 2001 965 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.