Listbox Row, Adjust?

[GUIDO22]

I don't suppose the ROWS in a listbox control can be adjusted i have multiline text i need to display.
If not i suspect the only way around this is to use continuous form display config with a multiline text box ..

 

[isladogs]

Suggest you use a subform instead of a listbox.

 

[SHANEMAC51]

SELECT W.ZID, W.ZTEXT_LIST
FROM (SELECT tblDTO.[zID], MID(tblDTO.[ztext],1,30) AS ZTEXT_LIST,ZTEXT & "_1" AS ZTEXT_SORT
FROM tblDTO
UNION ALL SELECT tblDTO.[zID], "~~~" &MID(tblDTO.[ztext],31,30),ZTEXT & "_2"
FROM tblDTO WHERE LEN(ZTEXT)>20
UNION ALL SELECT tblDTO.[zID], "~~~" &MID(tblDTO.[ztext],61,30),ZTEXT & "_3"
FROM tblDTO WHERE LEN(ZTEXT)>20
ORDER BY 3)  AS W;

 

[MajP]

.Additem problem

My db is not relational. Everything is in one table so I've no need for P or F keys, and their complications. And you wonder why your struggling?

www.access-programmers.co.uk

There is a class in there to wrap any listbox regardless of list width. There are two versions. You pretty much need a temp table if you want the wrap to be indented with a space.

 

[isladogs]

@MajP
I'd not seen that example before and its very clever.
At first sight it does appear to split the listbox items into more than one line
...but of course the multiple lines are generated by splitting the items themselves, each of which can then be selected separately.

I think that @SHANEMAC51 was showing the same idea

So to my mind, it's this is still not achieving the OP's requirements which I believe is having the same listbox item on more than one row...which AFAIK cannot be done

 

[MajP]

@isladogs, yes AFAIK there is no such control. Maybe a third party exists. FYI i used your code to determine the width of the string based on the font. It is a pretty good fake.

 

[isladogs]

Glad to see it being used. Wizhook rules ...

 

[isladogs]

I've just created a simple DEMO for another listbox thread started by @GUIDO22
See post #12 of Listbox Row Tooltip | Access World Forums (access-programmers.co.uk)

In that demo, I've created a multiline tooltip which may possibly be an acceptable solution for this thread also