Wrapping text in a list box

[sablegolesprata]

Hello!
I'm new in this forum and am apealling to you for help.
I'm using a Listbox based on a Table, and I've selected "yes" on the Column Heads format option. Whenever the field name is bigger than the Column Width I defined it's cutted.
Since Access doesn't allow (I think) to put carriage returns or line feeds in Table fileds names (I tryed like this: MyDB.TableDefs("XTmpHosp0").Fields(8).Name = "RSU" & Chr(10) & Chr(13) & "A28I04"), I then tryed to put a space between words hopping that it would show the field name in 2 separate lines ("RSU A28I04") but it didn't work.
Is there a way to wrap text like you do for a Cell in Excell?
I'm using Access 97.

João

 

[Peter D]

That's just the way that listboxes work. You might want to try using a datasheet subform or continuous form subform instead of a list box to get word wrapping to happen

Hope this helps,

 

[sablegolesprata]

Hi Peter!
Thanks a lot for your help. I've been experimenting with subforms, but since I've never done anything before with them I would like to ask you if you could give me some example.
I don't know if you undertood this detail, but the only thing I need text wrapping in is the Field Names of the Table in which the Listbox is based. I would like the height of the date rows to stay the same as it is.

João