PDA

View Full Version : [SOLVED] Line break within a cell



joelle
05-11-2005, 12:16 PM
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
05-11-2005, 12:26 PM
ALT+ENTER it is, but I do not know how
to mark this resolved?

Nee

Killian
05-11-2005, 12:29 PM
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
05-11-2005, 12:29 PM
:hi: Look on Thread Tools on the green menu bar just above the first post.

Killian
05-11-2005, 12:30 PM
Ok... cool... go to the thread tools at the top of the first post