Results 1 to 2 of 2
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    vbCrLf is causing square box on last line


    I have the following code, it displays what I want on each line but on the last light because it is doing a "vbCrLf" it is leaving a square box symbol in my table. How should I go about getting rid of the square box?

    With rs
    If .RecordCount <> 0 Then
    .MoveFirst
    'start concatenating records
    Do While Not rs.EOF
    varConcat = varConcat & rs("[MH Component]") & " " & rs("[PACP Defect]") & vbCrLf
    .MoveNext
    Loop
    End If
    End With

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about removing the last vbCrLf *after* you drop out of the loop?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-30-2009, 12:54 PM
  2. Line-Bar Chart Issue
    By santoshpk in forum Reports
    Replies: 0
    Last Post: 03-17-2009, 02:47 PM
  3. Design In-Line Function ???
    By caljohn527 in forum Queries
    Replies: 0
    Last Post: 01-28-2009, 03:48 PM
  4. Replies: 3
    Last Post: 03-24-2006, 08:40 AM
  5. line skip in bookmarks
    By emilylu3 in forum Programming
    Replies: 0
    Last Post: 03-21-2006, 02:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums