Also another method is on the form MultiColumn, look at the code behind load multi column listbox.
----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, November 12, 2004 1:54 PM Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > Buddy > > Nice try, but same result. Actually, since the column's values are TEXT - > numbers and letters are possible, I had to change it to: > > (LJS(CTXT(FORMAT(invnum,'%%%%%%%%%%%%%%%%%%%%'),20)) > > but the result is the same - in the list box, R:Base just shrinks the size > of the data displayed based on the data in the set. > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Walker, Buddy" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, November 12, 2004 1:28 PM > Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > > David > Have you tried formating the number example > > (LJS(CTXT(FORMAT(invnum,'99999999999999999999')),20)) > > The 9s will suppress any 0s. If you want to show the preceding 0s then > just change the 9s to 0s. > > > Buddy > > -----Original Message----- > From: David M. Blocker [mailto:[EMAIL PROTECTED] > Sent: Friday, November 12, 2004 1:16 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Fixed widths for columns in variable list box > > > I've created a simple form with a variable list box, showing three columns: > > InvNum TEXT 15 > ImpDOIN DATE > ExistDOIN DATE > > The properties of the list box are: > > Source: InDupPik (view) > Key column: InvNum > Multiple columns checked > Columns chosen: > > (LJS(InvNum,20)),ImpDOIN,ExistDOIN > > WHERE clause: > WHERE ImportID = .fImportID ORDER BY InvNum > > I have checked off "Show lines" > > The problem is that the width of InvNum varies with the data being > displayed. If the longest invoice number is 6 characters, R:Base seems to > ignore the LJS and displays only the characters needed. This is all well, > but I have column headings as Static text controls on the form above each > column and it would be MUCH simpler to just locate these rather than go > through a complex calculation to find the widest value being displayed and > move the controls over so they stay above the columns. > > One work around I've found which I'm not crazy about is to change the > expression to: > > ((LJS(InvNum,20))+ '.'),ImpDOIN,ExistDOIN > > This places a period after each value and forces R:Base to show a fixed > width. But the period is very klugy. Is there a better solution? > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 >
