Multi line list box (1 Viewer)
- Thread starter DanielR
- Start date
I am trying to display 3 fields in a table format in a list box.
One of the fields contains notes and I would like to have the text wrap around to multi lines. Furthermore, I would like to have a line drawn between each record set with a vertical scroll bar.
Hope this makes sense.
One of the fields contains notes and I would like to have the text wrap around to multi lines. Furthermore, I would like to have a line drawn between each record set with a vertical scroll bar.
Hope this makes sense.
- Local time
- Today, 09:21
- Joined
- Jan 23, 2006
- Messages
- 15,378
What happens when you try it? Error number?
I think by default a list box entry will be 1 line. But, there's a lot of creativity out there, so someone may have customization that would apply.
If I had a longer text string say 78 characters and wanted to display it in several "lines", say line length 23 chars, an approach might be:
-dim a tmpstring
-take the text string.
-starting in position 23 look for space
--if found, then put the 23 chars to my tmpstring and add a vbcrlf
then start checking chars 24--to 46,
--if not found,then start working from 23 back(eg 22,21...) until you find a space (natural break so to speak)
-continue that process until the initial string has been processed.
move the tmpString to the output.
I don't know if this will work with a list box or not (it's just how you might approach converting a long string into multiple short strings on different "lines".
Good luck.
I think by default a list box entry will be 1 line. But, there's a lot of creativity out there, so someone may have customization that would apply.
If I had a longer text string say 78 characters and wanted to display it in several "lines", say line length 23 chars, an approach might be:
-dim a tmpstring
-take the text string.
-starting in position 23 look for space
--if found, then put the 23 chars to my tmpstring and add a vbcrlf
then start checking chars 24--to 46,
--if not found,then start working from 23 back(eg 22,21...) until you find a space (natural break so to speak)
-continue that process until the initial string has been processed.
move the tmpString to the output.
I don't know if this will work with a list box or not (it's just how you might approach converting a long string into multiple short strings on different "lines".
Good luck.
Last edited:
- Local time
- Today, 09:21
- Joined
- Jan 23, 2006
- Messages
- 15,378
Hmmm?
I suggest you do some google searching to find some database and access concepts and examples.
As for Recordset--here is a free video by Steve Bishop.
I suggest you do some google searching to find some database and access concepts and examples.
As for Recordset--here is a free video by Steve Bishop.
I will try to explain more clearly what I am looking to do:
I am looking at displaying a log showing 3 columns: task, username and dat.
When I display these 3 columns in a list box, I can only display 1 line per entry.
The task field sometimes requires several lines of text.
How can I display a multi line entry in a list box?
Does this clarify my intent?
I am looking at displaying a log showing 3 columns: task, username and dat.
When I display these 3 columns in a list box, I can only display 1 line per entry.
The task field sometimes requires several lines of text.
How can I display a multi line entry in a list box?
Does this clarify my intent?
isladogs
MVP / VIP
- Local time
- Today, 14:21
- Joined
- Jan 14, 2017
- Messages
- 18,213
Your intent is clear.
Even if it's possible to do, I think your listbox will look a mess if you do this.
I suggest a different approach which I use with both listboxes and continuous subforms which include lengthy text or memo fields. Use a double click event to open a popup form showing the full notes field in a textbox.
Even if it's possible to do, I think your listbox will look a mess if you do this.
I suggest a different approach which I use with both listboxes and continuous subforms which include lengthy text or memo fields. Use a double click event to open a popup form showing the full notes field in a textbox.
