Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Wrap text in table (2002)

    Hi,
    I have a list control on a form with many columns. One column contains data that is put in in memo format and can be quite long. Even making the width of the column quite wide does not always show all of the data. is there a way to either wrap the text or for all of the text to show if the user double clicks on the row containing the comment field.

    Thanks!
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Wrap text in table (2002)

    You cannot wrap text in a list box (I assume that is what you mean by "list control").

    You could put a text box near the list box with Control Source

    =[lstSomething].[Column](3)

    In this expression, lstSomething it the name of the list box, and 3 is one less than the column number you want to display (0 = first column, 1 = second column etc.)

    Or you could write code like this in the On Dbl Click event of the list box:

    Private Sub lstSomething_DblClick(Cancel As Integer)
    If Not Me.lsSomething.ListIndex = -1 Then
    MsgBox Me.lstSomething.Column(3)
    End If
    End Sub

    But that is probably irritating.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Wrap text in table (2002)

    Thanks Hans! I had started to set it up the way you had described in your first example and then thought I'd check to see if the listbox could somehow wrap cells like in Excel.
    Leesah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •