Gene Wirchenko wrote on 2013-10-29: > Dear Vixens and Reynards: > What is the best way to define a fixed reference to a column? > > When the operator tries to move away from the current row, I > want the current control's validation to be done, and if that > succeeds, then the row-level validation to be done. If the row-level > validation fails, I want to set the focus on the first (measuring > from the left) applicable control. > The issue: Gird's .ActiveColumn is according to the physical > order which may have changed from the start because columns can be > put in a different order. > An example from my app is the following validation rule: > basicchg+ovrhdfee=dsbamt+xsvamt > If the columns were still in that order, the row-level validation > failing, the focus should go to the basicchg control. If the order > were changed to, say, > dsbamt xsvamt basicchg ovrhdfee > then the focus should go to the dsbamt control. How do I find out > which control is the leftmost? > Suppose I just want the basicchg control to get the focus. How > do I figure out its .ActiveColumn (or do an equivalent thing) so that > I can .setFocus() appropriately. > > Sincerely, > > Gene Wirchenko
Gene, You have the object name of the column, reference it to find the ColumnOrder property. This tells you which order it is in. The Column also has a Movable property which will prevent a user from moving the column. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
