Line break within a cell

[joelle]

Just quick question:
If you have lots of texts within one cell, how do you insert a line break between the text without having to insert spaces until the text flows to another line when displayed. Pls see my quick drawing:

--------------------------------------------
' djfljjdfasdasdfsafsafjfdlsfj.[line brk] '
' Moretextsdlfjldjfldjfldsjfldsjfldsjfld '
' dl;fjldjfldsjfldsjflkasdjfjsdljflksdjfl '
' dl;fjldjfldsjfldsjflkasdjfjsdljflksdj '
' dl;fjldjfldsjfldsjflkasdjfjs. '
--------------------------------------------

Thanks a lot.
Nee

[joelle]

ALT+ENTER it is, but I do not know how
to mark this resolved?

Nee

[Killian]

Hiya

I deleted your cross post in the Access forum - thanx for the tip off

So to your question... is there any reason you can't just turn text wrapping on for the cells concerned (Format > Cells > Alignment tab > check Wrap Text) or use

targetrange.WrapText = True

[BlueCactus]

Look on Thread Tools on the green menu bar just above the first post.

[Killian]

Ok... cool... go to the thread tools at the top of the first post