Spread 8.0 Documentation
QueryAdvance, ScriptQueryAdvance Events
Support Options
ActiveX Reference > ActiveX Events > QueryAdvance, ScriptQueryAdvance Events

Glossary Item Box

QueryAdvance, ScriptQueryAdvance Events


See Also

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 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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.