----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, November 13, 2004 3:56 PM Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box
> Mike > > I see that these work and are just what I want so I'll use them! This is > great stuff! > > A few questions for you so I can understand what I'm doing and not just copy > it slavishly, thought that certainly has its place! > > > > 1. What is CHAR(160)? What character is that? It appears to be a > hard space? Whatever it is, it actually helped MY workaround! Instead of > using > > ((LJS(InvNum,20))+ '.'),ImpDOIN,ExistDOIN > > I used: > > ((LJS(InvNum,20))+ CHAR(160)),ImpDOIN,ExistDOIN > > and the regular list box now lines up correctly! > Yes a Hard Space.. > > 2. Not all properties of the Variable User Defined Listboxes that you > use are documented in the current version of R:Docs. Can you clarify what > they do? > > 1. From Form Rolodex, On After Start EEP: > > 1. PROPERTY lbrolodex listitemsclear 'TRUE' - does this clear out any > items in the box? Yes.. > 2. PROPERTY lbrolodex multiselect 'TRUE' - what does this do? It sets the Listbox to allow the selection of multiple items, but it should not be used in a production app yet as there is no corresponding Property to determine the indexes of the items that are highlighted in the multiple selection. I used a cheat of a hidden listbox to add or remove items that are selected, but the caveat is that it only works when items are added to the selection One At A Time, so steer clear of it for now. > 3. PROPERTY lbrolodex load_from_file 'Rolodex.lff' - this one is > clear - it loads the list box from the file Yes > 2. Those on form MultiCol are documented. > > > > > > By the way, in running Rolodex from RUN STARTUP.RMD, in the latest beta > build 78, if you select one of the addresses a smaller form comes up showing > more details about that address. At that point you are hung and need a > ctrl-alt-del to continue. No key or mouse strokes get you out of that > popped up form. Any idea what this is about? > If you notice the slightly off color horiz bar at the top and the verticle bar at the right, that is a pushbutton that closes the form. It was just doing something a little different for the demo, not something you would sneak into a production app. > > Many thanks! > > > > 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 > > > > > >
