List Box Properties

[moppsy]

Need Help. We have a list box that holds long company names. However, it appears that company names greater then 50 characters are being cut off. Is there a property to set this limit higher? Thanks in advance.

 

[Nifrabar]

Hi!
Are you sure that the source for your listbox holds the right source? Is that possibly an sql-cursor? In that case and if the first record of that cursor holds just only 40 characters all other rows will have 40 characters with too.
-Bart

 

[moppsy]

Thanks Bart, now I need to know how to increase from let say 40 characters or how to change from a non sql-cursor? Thanks again.

 

[Nifrabar]

select PADL(myField1,50) from myTable into Cursor myCursor order by myField
Might be a good cursor as source. That way all myField1 will hold always 50 characters.
-Bart

 

[crewchiefpro6]

You could also set the column width to a higher number


Don Higgins

http://www.crewchiefpro.com

 

[alvechurchdata]

PADL(myField1,50)

PADL gives leading spaces. PADR might look better because that adds trailing spaces.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Nifrabar]

oops..! you'r right Geoff
-Bart