Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to insert a line break

Status
Not open for further replies.

DomFino

IS-IT--Management
Jul 9, 2003
278
0
0
US
In the following code, I want to insert a line break where the & chr34 showes at the end of a line, however it is not working. Is there another way to force the text to display in multiple lines?
Thanks for your help,
Dom

Code:
With ppPres
        While Not rs.EOF
            With .Slides.Add(rs.AbsolutePosition + 1, ppLayoutTitle)
                .Shapes(1).TextFrame.TextRange.Text = "Starts This Week!  # " & rs.AbsolutePosition + 1
                .SlideShowTransition.EntryEffect = ppEffectFade
                With .Shapes(2).TextFrame.TextRange
                    .Text = CStr(rs.Fields("Fname").Value) & " " & CStr(rs.Fields("Lname").Value) & Chr(34) & _
                            CStr(rs.Fields("Customer").Value) & Chr(34) & _
                            CStr(rs.Fields("Start Date").Value) & Chr(34) & _
                            CStr(rs.Fields("SalesRep").Value) & " " & CStr(rs.Fields("Recruiter").Value)
                    .Characters.Font.Color.RGB = RGB(255, 0, 255)
                    .Characters.Font.Shadow = True
                End With
                .Shapes(1).TextFrame.TextRange.Characters.Font.Size = 50
            End With
            rs.MoveNext
        Wend
    End With
 
Like this ?
... & Chr(34) & vbCrLf & _

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
PHV,
Thank you so much. That worked like a charm.
Dom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top