J
josh g
I want to display text (Over 256 characters w/ Carriage
Returns) in a text box from double clicking on a list
box. I was able to display the first line of text in
another list box, but b/c of the CRLF, the rest of the
info was not displayed. I was able to display more than
one line using a combo box, but i have to select the
record and it only displays 256 characters so a good
portion of the info was cut off. Therefore, I'm trying to
display the info in a text box, however, I'm not sure of
the fuction to use. The below code is what works for the
Listbox or combobox, but for a text box there is no
RowSource option. Please advise. Many thanks. Josh
Private Sub RelatedMessages_DblClick(Cancel As Integer)
If Me!RelatedMessages.Value <> "" Then
With Me!Combo52
strSQL = strSQL4 & "'" & Me!
RelatedMessages.Value & "'" & ";"
.RowSource = strSQL
.Requery
End With
End If
End Sub
Returns) in a text box from double clicking on a list
box. I was able to display the first line of text in
another list box, but b/c of the CRLF, the rest of the
info was not displayed. I was able to display more than
one line using a combo box, but i have to select the
record and it only displays 256 characters so a good
portion of the info was cut off. Therefore, I'm trying to
display the info in a text box, however, I'm not sure of
the fuction to use. The below code is what works for the
Listbox or combobox, but for a text box there is no
RowSource option. Please advise. Many thanks. Josh
Private Sub RelatedMessages_DblClick(Cancel As Integer)
If Me!RelatedMessages.Value <> "" Then
With Me!Combo52
strSQL = strSQL4 & "'" & Me!
RelatedMessages.Value & "'" & ";"
.RowSource = strSQL
.Requery
End With
End If
End Sub