R:azzak: Those options/tricks work rather nicely in 7.1, where I believe Jan said got them originally. I have posted these "tricks" to the List before as a way to fine tune pop-ups in 7.1; obviously they do not work in 7.5 as it already provides the tools to customize pop-ups without the "tricks" Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Tuesday, July 26, 2005 4:39 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 problem At 05:25 PM 7/26/2005, Jan Johansen wrote: >Here's the WHERE clause from the WHERE Clause block in the DB-Edit .... > >WHERE EmpStatus = 'Y' AND EmpLevel NOT IN (0) ORDER BY EmpFirstName ASC >TITLE 'Select Technician...' CAPTION 'Employee Name...' LINES 20 OPTION >LIST_FONT_NAME Courier | LIST_FONT_SIZE 12 > >Once I removed everything from TITLE to the end the popup worked fine. I >had removed from LINES to the end just to see if it would work at first >but it didn't. Jan, Where in the world did you see the support for additional options in the "WHERE clause" of Pop-up menus for DB/Variable Edit Controls? Are you dreaming or too much vacation? <g> The WHERE clause, in your case should only include the following: WHERE EmpStatus = 'Y' AND EmpLevel NOT IN (0) ORDER BY EmpFirstName ASC If you need to customize that Pop-up Menu, use the latest enhanced Pop-up Menu designer options as suggested in: Tip of the Day: Tip of the Day: Designing Custom Pop-up Menus (07/26/2005) Here's how (using the latest RBG75, Build: 7.5.12.30725 or higher): Form Designer|DB Edit|Variable Edit Properties|Pop-up Menus Notice the following additional options: . Show Lines (to separate multiple columns for a better look) . Title Font and Color . List Font and Color . Title Background Color . List Background Color That's all there is to it! Very Best R:egards, Razzak.
