Thanks MIke I'll look at this today
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, November 13, 2004 9:26 AM Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > 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 > > >
