----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 9:41 AM Subject: [RBG7-L] - Re: What's the difference
> Great question and great answers, Dawn, Larry and Razzak! > > Adding my two cents worth > > 1. For me, real estate is the key reason for using a Combo box vs. a list > box, as Razzak pointed out > > 2. Lines are an important feature when displaying multiple columns, a > reason I lean toward Lookup list boxes > > 3. However, the nifty method Mike B developed allows you to circumvent the > limitations Larry mentioned if you use a VARIABLE user defined list box. > The list does NOT have to be "typed in by hand" but CAN come from one or > MORE columns in a table. I just installed an upgrade at a client's that > does just that. The only limitation I've found of mulitple columns is that > in order to get them to align in columns, since you can't use the LINES > feature, you must use a fixed font like Courier. > > And Larry, I know you've posted this before, but can you supply some more > details about the two list box method, allowing users to move data from one > to the other? The Old tech method (Kludge) of multi copy from one to another is on my Spring 2004 demo, but the button isn't placed between the two listboxes, it is at the bottom. Just run the Multi Select ListBox portion of the demo to copy from one to another. The New Tech way is available on the current update by using the CheckedState property of the item and if it is 'Selected' then move it to the new listbox. There is another demo on the spring cd that moves an item from one listbox to another on the OnClick event in the "From" listbox. This is the "Multi Col Listboxes LFF and Cursor" portion of the Demo. I'm thinking about a more comprehensive "How To" Demo that I might put together on One Form to cover the User Defined Listboxes and Combo Boxes to provide fully commented code, that will be of help to people still unclear on how these things work, and provide easily portable code for their own projects. I can see from the posts that some folks are getting the hang of the mechanics of these controls, but others are still have questions and in the absence of understanding, they may be missing the full utilization of these flexible controls... > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "A. Razzak Memon" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, December 01, 2004 12:11 AM > Subject: [RBG7-L] - Re: What's the difference > > > > > > At 04:00 PM 11/30/2004 -0600, Marc Schluter wrote: > > > > >What are the advantages / disadvantages between, > > >in other words why would I use one over the other?? > > > > > >DB Look up ComboBox > > >DB Look up List Box > > >DB User Defined Combo Box > > >DB User Defined List Box > > > > > > Marc, > > > > That would be a perfect article for FTE! > > From The Edge: http://www.razzak.com/fte > > > > While I prepare the article (time permitting), here's > > a quick version of a few distinct reasons to use one > > control (ComboBox) over another (ListBox): > > > > General: > > > > 01. Available Real-Estate on the Form > > ListBox requires "fixed" width and height to > > display list items. > > > > 02. Look and Feel > > > > 03. See Dawn Oakes and Larry Lustig's comments > > > > Specific: > > > > A. DB Lookup ComboBox vs. DB User Defined ComboBox > > > > 01. DB Lookup ComboBox > > . Lookups are based on Tables/Values > > . Can use WHERE clause to customize values > > . Can show lines > > . Supported/Documented PROPERTY Commands: > > - ALIGN > > - AUTODROPDOWN > > - COLOR > > - DROPDOWNCOUNT > > - DROPDOWNWIDTH > > - ENABLED > > - FLATBUTTONS > > - FRAMEVISIBLE > > - HEIGHT > > - HINT > > - ITEMHEIGHT > > - LEFT > > - LISTOPEN > > - REFRESHLIST > > - SHOWHINT > > - SHOWLINES > > - TABORDER > > - TABSTOP > > - TOP > > - VISIBLE > > - WIDTH > > > > 02. DB User Defined ComboBox > > . Lookups are hard-coded values > > . Values can be "Editable" > > . Lookups can be expressions > > . Values can be saved to a file > > . Cannot show lines > > . Supported/Documented PROPERTY Commands: > > - ALIGN > > - AUTODROPDOWN > > - COLOR > > - DELIMITER > > - DROPDOWNCOUNT > > - DROPDOWNWIDTH > > - ENABLED > > - FLATBUTTONS > > - FRAMEVISIBLE > > - HEIGHT > > - HINT > > - ITEMHEIGHT > > - ITEMINDEX > > - LEFT > > - LISTCOUNT > > - LISTITEMS > > - LISTITEMSADD > > - LISTITEMSADDDELIMITEDTEXT > > - LISTITEMSCLEAR > > - LISTITEMSDELETE > > - LISTITEMSREFRESH > > - LISTOPEN > > - LOAD_FROM_FILE > > - READONLY > > - SAVE_TO_FILE > > - SELECTION > > - SHOWHINT > > - TABORDER > > - TABSTOP > > - TOP > > - VISIBLE > > - WIDTH > > > > B. DB Lookup ListBox vs. DB User Defined ListBox > > > > 01. DB Lookup ListBox > > . Lookups are based on Tables/Values > > . Can use WHERE clause to customize values > > . Can show lines > > . Supported/Documented PROPERTY Commands: > > - ALIGN > > - ALIGNMENT > > - COLOR > > - COLUMNS > > - ENABLED > > - FRAMEVISIBLE > > - HEIGHT > > - HINT > > - HORZEXTENT > > - HORZSCROLLBAR > > - ITEMHEIGHT > > - ITEMINDEX > > - LEFT > > - REFRESHLIST > > - SHOWHINT > > - SHOWLINES > > - TABORDER > > - TABSTOP > > - TABWIDTH > > - TOP > > - VISIBLE > > - WIDTH > > > > 02. DB User Defined ListBox > > . Lookups are hard-coded values > > . Lookups can be expressions > > . May use external file to load values > > . Values can be saved to a file > > . Supports SELECT n, UNSELECT n, CHECKINDEX n > > and SELECTEDSTATE PROPERTY commands. > > . Cannot show lines > > . Supported/Documented PROPERTY Commands: > > - ALIGN > > - CHECKINDEX > > - COLOR > > - COLUMNS > > - DELIMITER > > - ENABLED > > - FRAMEVISIBLE > > - HEIGHT > > - HORZEXTENT > > - HINT > > - HORZEXTENT > > - HORZSCROLLBAR > > - ITEMHEIGHT > > - ITEMINDEX > > - LEFT > > - LISTCOUNT > > - LISTITEMS > > - LISTITEMSADD > > - LISTITEMSADDDELIMITEDTEXT > > - LISTITEMSCLEAR > > - LISTITEMSDELETE > > - LISTITEMSREFRESH > > - LOAD_FROM_FILE > > - READONLY > > - SAVE_TO_FILE > > - SCROLLWIDTH > > - SELECT > > - SELECTEDSTATE > > - SELECTION > > - SHOWHINT > > - TABORDER > > - TABSTOP > > - TABWIDTH > > - TOP > > - UNSELECT > > - VISIBLE > > - WIDTH > > > > Stay tuned for more descriptive version at FTE! > > > > Very Best R:egards, > > > > Razzak. > > >
