QueryAdvance, ScriptQueryAdvance Events
Applies To
fpSpread control
Description
Occurs when the user moves the focus to the next or previous control on the form.
Syntax
Visual Basic
Sub fpSpread_QueryAdvance(ByVal AdvanceNext As Boolean, Cancel As Boolean)
Note: The ScriptQueryAdvance event uses the same syntax except event parameters that are not passed "ByVal" are declared as variants. For more information on Script events, see Scripting Environment Usage. |
Parameters
The following parameters are available:
Parameter | Description |
---|---|
AdvanceNext | True if the user pressed the Tab or down arrow key; False if the user pressed Shift+Tab or the up arrow key |
Cancel | Defaults to True and the focus stays within the fpSpread control (Set this value to False to let the focus move to the next or previous control on the form. If True, the user cannot move the focus.) |
Remarks
This event occurs when the focus is in
- the upper-left cell and the user presses Shift+Tab
- the lower-right cell and the user presses the Tab key
- the top row and the user presses the up arrow key
- the bottom row and the user presses the down arrow key
The application responds by moving the focus to the next or previous control on the form.
You must set the ProcessTab property to True for the QueryAdvance event to occur when the user presses the Tab key or Shift+Tab.
Note: This event will occur if you use the fpSpread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the fpSpread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and use the ScriptQueryAdvance event. ScriptQueryAdvance event parameters that are not passed "ByVal" are declared as variants. |
See Also
ScriptEnhanced property