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.