maggiemel
Posts: 75
|
| Posted: 06/16/2005, 10:22 AM |
|
Hello, everybody. I have a listbox on one of my forms and some of the values are very long, causing my page to appear with a horizontal scrollbar (yuck!)
I'm not sure how to trim the value of the text in the listbox. I tried using:
FormName.ListboxName.Value = Left(FormName.ListboxName.Value, 50) & "..."
but that didn't seem to do anything. Maybe I'm referencing the listbox incorrectly?
Probably something simple -- I'm suffering a little brain drain today.
Thanks in advance.
Melissa
_________________
Melissa Cahill
http://www.hellcatmaggie.net/ |
 |
 |
E43509
Posts: 283
|
| Posted: 06/16/2005, 11:56 AM |
|
If you are selecting data from the database, why not do the trimming when you do the select? Select substr(myfield, 1,10) from mytable (oracle syntax)
|
|
|
|
|
