Text box Access 2007 - no multiline property

[AlexanderBB]

Hi,

How can I see text on each line ? No multiline property and at the moment they do not wrap with vblf .

Thanks

 

[ranman256]

vbCrLf

 

[AlexanderBB]

Thanks, I had tried that but suspect something else is wrong - or my logic.
I've bound a Form to a query and a text box to one of the fields. But the field uses vblf which doesn't wordwrap in the text box.
So I tried this code - which had no effect.

Private Sub Form_Current()
Dim Disp As String
Disp = Replace(Me.Text4, vbLf, vbCrLf)
Me.Text4 = Disp
End Sub

I was attempting to display the text with LFs in the text box, but not change the underlying table. Now I wondering if that is wrong?

BTW when you click in datasheet view, why does part of the text/cell become highlighted or selected. How can you get your edit cursor?

Thanks

 

[Micron]

I don't think you can use vbCrLf to force a new line in a control. Try Chr(13) & Chr(10) in that order.
If you're highlighting part of the field contents when you try to insert the cursor, you have probably hit F8 and turned on extend mode when intending to step through code but the database was the active window and not the vb editor. Shift F8 turns it off.