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
