This chapter contains a collection of controls that are a dream-come-true for a Web-based database application GUI developer. The controls fall under the "formatted control" category. You can use these controls for getting different types of data from the user-for example, the fpCurrency control for getting dollar amount data and the fpBoolean control for option boxes and check boxes.
The controls are chosen for their compactness as well as their
functionality. Most of the controls are useful to build the front-end
Web forms to interface with Internet and intranet databases. Among
the various controls, the fpxxx series of controls from
FarPoint Technologies are very versatile and simple to use. As
you can see from fpxxx series' properties, methods, and
events, they are powerful enough to handle all your input needs.
| NOTE |
All the controls in this chapter are commercial controls. You can download demo versions from the ActiveX Gallery Web site or from the developer's Web site. But, if you plan to use them for your Web applications, you should purchase the controls. |
The fpBoolean is a very versatile two- or three-state ActiveX control. This formatted control can be used as a check box or as an option control. This control can be bound to byte, Boolean, numeric, or text values in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.1 : The fpBoolean control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignPictureH | The horizontal alignment of the picture |
| AlignPictureV | The vertical alignment of the picture |
| AlignTextH | The horizontal alignment of the text |
| AlignTextV | The vertical alignment of the text |
| AllowMnemonic | True, to allow the "&" as a valid character |
| Appearance | The border look-flat, #D, and so on |
| AutoToggle | True, to allow the user to toggle the value by using the space bar or clicking |
| BackColor | The background color of the object |
| BooleanMode | Two-state, three-state, or button |
| BooleanPicture | Check box, option button, or user-defined mode |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, or on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| Caption | The caption for the control |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| Enabled | True, to set the control to get focus and respond to UI |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| GroupID | The group number |
| GroupSelect | The rule for the controls in a group-no rule, any combination, no more than one, one and only one, one or more |
| GroupTag | The number inside the group-1, 2, 4, 8, and so on |
| GroupValue | The value of all the controls in a group |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| MultiLine | True, to set the text display in more than one line |
| PictureFalse | The picture that appears with the user-defined BooleanPicture property's False state. |
| PictureFalseDisabled | The picture that appears with the user-defined BooleanPicture property's False Disabled state |
| PictureFalseDown | The picture that appears with the user-defined BooleanPicture property's False Down state |
| PictureGrayed | The picture that appears with the user-defined BooleanPicture property's Grayed state |
| PictureGrayedDisabled | The picture that appears with the user-defined BooleanPicture property's Grayed Disabled state |
| PictureGrayedDown | The picture that appears with the user-defined BooleanPicture property's Grayed Down state |
| PictureTrue | The picture that appears with the user-defined BooleanPicture property's True state |
| PictureTrueDisabled | The picture that appears with the user-defined BooleanPicture property's True Disabled state |
| PictureTrueDown | The picture that appears with the user-defined BooleanPicture property's True Down state |
| ReDraw | Repaint the control |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| TextFalse | The text that appears for a False state |
| TextGrayed | The text that appears for a Grayed state |
| TextTrue | The text that appears for a True state |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| ToggleFalse | The character to toggle the control to False state |
| ToggleGrayed | The character to toggle the control to Grayed state |
| ToggleTrue | The character to toggle the control to True state |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Value | The numeric value of the state of the control |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpBoolean1" WIDTH=148 HEIGHT=32
CLASSID="CLSID:95C3A8D4-81CB-11CF-ADD0-00AA00A5053A">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="3138">
<PARAM NAME="_ExtentY" VALUE="662">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="12632256">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="1">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="1">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="AutoToggle" VALUE="-1">
<PARAM NAME="BooleanStyle" VALUE="0">
<PARAM NAME="ToggleFalse" VALUE="">
<PARAM NAME="TextFalse" VALUE="fpBoolean1-False">
<PARAM NAME="BooleanPicture" VALUE="0">
<PARAM NAME="AlignPictureH" VALUE="3">
<PARAM NAME="AlignPictureV" VALUE="1">
<PARAM NAME="GroupId" VALUE="1">
<PARAM NAME="GroupTag" VALUE="1">
<PARAM NAME="GroupSelect" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="MultiLine" VALUE="0">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="1">
<PARAM NAME="ToggleTrue" VALUE="">
<PARAM NAME="TextTrue" VALUE="fpBoolean1-True">
<PARAM NAME="Value" VALUE="0">
<PARAM NAME="BooleanMode" VALUE="0">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ToggleGrayed" VALUE="">
<PARAM NAME="TextGrayed" VALUE="fpBoolean1-Grayed">
<PARAM NAME="AllowMnemonic" VALUE="-1">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="1">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
<P>
<OBJECT ID="fpBoolean2" WIDTH=148 HEIGHT=43
CLASSID="CLSID:95C3A8D4-81CB-11CF-ADD0-00AA00A5053A">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="3138">
<PARAM NAME="_ExtentY" VALUE="917">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="12632256">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="1">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="1">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="AutoToggle" VALUE="-1">
<PARAM NAME="BooleanStyle" VALUE="0">
<PARAM NAME="ToggleFalse" VALUE="">
<PARAM NAME="TextFalse" VALUE="fpBoolean2-False">
<PARAM NAME="BooleanPicture" VALUE="0">
<PARAM NAME="AlignPictureH" VALUE="3">
<PARAM NAME="AlignPictureV" VALUE="1">
<PARAM NAME="GroupId" VALUE="1">
<PARAM NAME="GroupTag" VALUE="1">
<PARAM NAME="GroupSelect" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="MultiLine" VALUE="0">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="1">
<PARAM NAME="ToggleTrue" VALUE="">
<PARAM NAME="TextTrue" VALUE="fpBoolean2-True">
<PARAM NAME="Value" VALUE="0">
<PARAM NAME="BooleanMode" VALUE="0">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ToggleGrayed" VALUE="">
<PARAM NAME="TextGrayed" VALUE="fpBoolean2-Grayed">
<PARAM NAME="AllowMnemonic" VALUE="-1">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="-1">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="1">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT></BODY>
</HTML>
This is a very versatile control. It can even have different captions depending on the button state. Additionally, you can make it totally pictorial and have a separate graphic for each state.
The fpCurrency is a formatted currency and numeric data-entry ActiveX control. It performs validation for invalid characters, a range of values, and so on. This control can be bound to numeric, currency, or text values in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.2 : The fpCurrency control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignTextH | The horizontal alignment of the picture |
| AlignTextV | The vertical alignment of the picture |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDefaultAction | True, to enable the default action for the spin button |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| CurrencyDecimalPlaces | The number of decimal places |
| CurrencyNegFormat | The appearance when the number is negative |
| CurrencyPlacement | The placement of the currency symbol |
| CurrencySymbol | The currency symbol |
| CurrentPosition | The current position of the cursor |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| DecimalPoint | The character to be used for decimal point |
| Enabled | True, to set the control to get focus and respond to UI |
| FixedPoint | True, to display zeroes to the right of decimal place |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| IncDec | The decimal portion increment when using the button |
| IncInt | The integer portion increment when using the button |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | Action for invalid data when the control loses focus-show data, hide data, clear data |
| LeadZero | The leading zero display option |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| MaxValue | The upper limit for the control value |
| MinValue | The lower limit for the control value |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NegToggle | True, to allow the user to enter negative value |
| NoSpecialKeys | Option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select the data in the control when it gets focus |
| OnFocusPosition | The position of the cursor in the data in the control when it gets focus |
| Separator | The thousands separator character |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserEntry | Formatted or free format |
| UseSparator | True, to display the thousands separator character |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by ther user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpCurrency1" WIDTH=135 HEIGHT=32
CLASSID="CLSID:59834660-C0FE-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="2863">
<PARAM NAME="_ExtentY" VALUE="662">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="1">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="1">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="10000">
<PARAM NAME="ButtonStyle" VALUE="1">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="$0.00">
<PARAM NAME="CurrencyDecimalPlaces" VALUE="-1">
<PARAM NAME="CurrencyNegFormat" VALUE="0">
<PARAM NAME="CurrencyPlacement" VALUE="0">
<PARAM NAME="CurrencySymbol" VALUE="$">
<PARAM NAME="DecimalPoint" VALUE="">
<PARAM NAME="FixedPoint" VALUE="-1">
<PARAM NAME="LeadZero" VALUE="0">
<PARAM NAME="MaxValue" VALUE="100000">
<PARAM NAME="MinValue" VALUE="0">
<PARAM NAME="NegToggle" VALUE="0">
<PARAM NAME="Separator" VALUE="">
<PARAM NAME="UseSeparator" VALUE="-1">
<PARAM NAME="IncInt" VALUE="1">
<PARAM NAME="IncDec" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="3">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
<P>
<OBJECT ID="fpCurrency1" WIDTH=200 HEIGHT=32
CLASSID="CLSID:59834660-C0FE-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="4233">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="4">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="$0.00">
<PARAM NAME="CurrencyDecimalPlaces" VALUE="-1">
<PARAM NAME="CurrencyNegFormat" VALUE="0">
<PARAM NAME="CurrencyPlacement" VALUE="0">
<PARAM NAME="CurrencySymbol" VALUE="">
<PARAM NAME="DecimalPoint" VALUE=".">
<PARAM NAME="FixedPoint" VALUE="-1">
<PARAM NAME="LeadZero" VALUE="0">
<PARAM NAME="MaxValue" VALUE="10000">
<PARAM NAME="MinValue" VALUE="-100000">
<PARAM NAME="NegToggle" VALUE="0">
<PARAM NAME="Separator" VALUE="">
<PARAM NAME="UseSeparator" VALUE="-1">
<PARAM NAME="IncInt" VALUE="1">
<PARAM NAME="IncDec" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The fpDateTime is a formatted date and time data-entry ActiveX control. It performs validation for invalid characters, a range of dates, and so on. This control can be bound to date, time, or text values in the back-end database. One of the interesting features of this control is the capability to select data from a drop-down or popup calendar.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.3 : The fpDateTime control drop-down calendar
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
Figure 14.4 : The fpDateTime control popup calendar
| Property | Description |
| AlignTextH | The horizontal alignment of the text |
| AlignTextV | The vertical alignment of the text |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDefaultAction | True, to enable the default action for the spin button |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| CurrentPosition | The current position of the cursor |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| DateCalcMethod | The method for calculating missing date and time values-Current Date/Time, User Defined Date/Time, 50/50, Future |
| DateDefault | The default date displayed when the control is initialized |
| DateMax | The upper limit for the date entry |
| DateMin | The lower limit for date entry |
| DateTimeFormat | The format of the date/time |
| Day | The day value of the date in the control |
| Enabled | True, to set the control to get focus and respond to UI |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | Action for invalid data when the control loses focus-show data, hide data, clear data |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| Month | The month value of the date in the control |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NoSpecialKeys | Option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select the data in the control when it gets focus |
| OnFocusPosition | The position of the cursor in the data in the control when it gets focus |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| TimeDefault | The default time that appears when the control is initialized |
| TimeMax | The upper limit for the time entry |
| TimeMin | The lower limit for date entry |
| TimeString1159 | The string to indicate morning, for example, am |
| TimeString2359 | The string to indicate evening, for example, pm |
| TimeStyle | The style for time display: 12-hour, 24-hour, and so on |
| TimeValue | The value of time in the control |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UnFmtText | The control text without any formatting |
| UserDefinedFormat | The format for display for user-defined format |
| UserEntry | Formatted or free format |
| Visible | False to hide the control |
| Width | The width of the control in points |
| Year | The year value of the date in the control |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when the user presses a button |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation or, function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| Popup | Triggers when the popup calendar is activated |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>Jyothi's Page Page</TITLE>
</HEAD>
<BODY>
<P>
<TEXT> With drop-down Calendar</TEXT>
<P>
<OBJECT ID="fpDateTime1" WIDTH=238 HEIGHT=32
CLASSID="CLSID:B8958DE0-BAC9-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="5045">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="16777215">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="3">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="1">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="Thursday, November 28, 1996">
<PARAM NAME="DateCalcMethod" VALUE="0">
<PARAM NAME="DateTimeFormat" VALUE="1">
<PARAM NAME="UserDefinedFormat" VALUE="">
<PARAM NAME="DateMax" VALUE="00000000">
<PARAM NAME="DateMin" VALUE="00000000">
<PARAM NAME="TimeMax" VALUE="000000">
<PARAM NAME="TimeMin" VALUE="000000">
<PARAM NAME="TimeString1159" VALUE="">
<PARAM NAME="TimeString2359" VALUE="">
<PARAM NAME="DateDefault" VALUE="00000000">
<PARAM NAME="TimeDefault" VALUE="000000">
<PARAM NAME="TimeStyle" VALUE="0">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
<P>
<TEXT> With popup Calendar</TEXT>
<P>
<OBJECT ID="fpDateTime1" WIDTH=213 HEIGHT=32
CLASSID="CLSID:B8958DE0-BAC9-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="4514">
<PARAM NAME="_ExtentY" VALUE="662">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="2">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="1">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="fpDateTime1">
<PARAM NAME="DateCalcMethod" VALUE="0">
<PARAM NAME="DateTimeFormat" VALUE="0">
<PARAM NAME="UserDefinedFormat" VALUE="">
<PARAM NAME="DateMax" VALUE="00000000">
<PARAM NAME="DateMin" VALUE="00000000">
<PARAM NAME="TimeMax" VALUE="000000">
<PARAM NAME="TimeMin" VALUE="000000">
<PARAM NAME="TimeString1159" VALUE="">
<PARAM NAME="TimeString2359" VALUE="">
<PARAM NAME="DateDefault" VALUE="00000000">
<PARAM NAME="TimeDefault" VALUE="000000">
<PARAM NAME="TimeStyle" VALUE="0">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="1">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
This control is essential in the tool box of any Web designer. The user-friendly popup or drop-down calendar is becoming an essential feature for data-entry systems.
The fpDoubleSingle is a formatted, decimal, numeric data-entry ActiveX control. It performs validation for invalid characters, a range of values, and so on. This control can be bound to numeric or text values in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.5 : The fpDoubleSingle control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignTextH | The horizontal alignment of the text |
| AlignTextv | The vertical alignment of the text |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDefaultAction | True, to enable the default action for the spin button |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| DecimalPlaces | The number of decimal places in the control |
| DecimalPoint | The character to be used for decimal point |
| Enabled | True, to set the control to get focus and respond to UI |
| FixedPoint | True, to display zeroes to the right of decimal place |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| Hwnd | The handle for the window |
| ID | The name of the object/control |
| IncDec | The decimal portion increment when using the button |
| IncInt | The integer portion increment when using the button |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | The action for invalid data when the control loses focus-show data, hide data, clear data |
| LeadZero | The leading zero display option |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| MaxValue | The upper limit for the control value |
| MinValue | The lower limit for the control value |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NegFormat | The display format for negative numbers |
| NegToggle | True, to allow the user to enter negative value |
| NoSpecialKeys | The option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select the data in the control when it gets focus |
| OnFocusPosition | The position of the cursor in the data in the control when it gets focus |
| Separator | The thousands separator character |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserEntry | Formatted or free format |
| UseSparator | True, to display the thousands separator character |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpDoubleSingle1" WIDTH=135 HEIGHT=32
CLASSID="CLSID:B8958DE5-BAC9-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="2858">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="3">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="4">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="0.00">
<PARAM NAME="DecimalPlaces" VALUE="-1">
<PARAM NAME="DecimalPoint" VALUE="">
<PARAM NAME="FixedPoint" VALUE="-1">
<PARAM NAME="LeadZero" VALUE="0">
<PARAM NAME="MaxValue" VALUE="9000000000">
<PARAM NAME="MinValue" VALUE="-9000000000">
<PARAM NAME="NegFormat" VALUE="1">
<PARAM NAME="NegToggle" VALUE="0">
<PARAM NAME="Separator" VALUE="">
<PARAM NAME="UseSeparator" VALUE="0">
<PARAM NAME="IncInt" VALUE="1">
<PARAM NAME="IncDec" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The fpLongInteger is a formatted, numeric data-entry ActiveX control. It performs validation for invalid characters, a range of values, and so on. This control can be bound to numeric or text values in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.6 : The fpLongInteger control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignTextH | The horizontal alignment of the text |
| AlignTextV | The vertical alignment of the text |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDefaultAction | True, to enable the default action for the spin button |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| Enabled | True, to set the control to get focus and respond to UI |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| IncDec | The decimal portion increment when using the button |
| IncInt | The integer portion increment when using the button |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | The action for invalid data when the control loses focus-show data, hide data, clear data |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| MaxValue | The upper limit for the control value |
| MinValue | The lower limit for the control value |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NegFormat | The display format for negative numbers |
| NegToggle | True, to allow the user to enter negative value |
| NoSpecialKeys | The option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select the data in the control when it gets focus |
| OnFocusPosition | The position of the cursor in the data in the control when it gets focus |
| Separator | The thousands separator character |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserEntry | Formatted or free format |
| UseSparator | True, to display the thousands separator character |
| Value | The value of the data in the control |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpLongInteger1" WIDTH=148 HEIGHT=32
CLASSID="CLSID:B8958DEF-BAC9-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="3140">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="1">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="fpLongInteger1">
<PARAM NAME="MaxValue" VALUE="2147483647">
<PARAM NAME="MinValue" VALUE="-2147483648">
<PARAM NAME="NegFormat" VALUE="1">
<PARAM NAME="NegToggle" VALUE="0">
<PARAM NAME="Separator" VALUE="">
<PARAM NAME="UseSeparator" VALUE="0">
<PARAM NAME="IncInt" VALUE="1">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The fpMask is a formatted data-entry ActiveX control. This control can be used for any type of data entry, such as Social Security numbers, phone numbers, and ZIP codes. It performs validation for invalid characters, a range of values, and so on. This control can be bound to any type of value (except binary type) in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.7 : The fpMask control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignTextH | The horizontal alignment of the text |
| AlignTextV | The vertical alignment of the text |
| AllowNull | True, to allow the user the capability to leave this control blank |
| AllowOverflow | True, to allow the user to enter more characters on a full control |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| AutoTab | True, to go to next control by using the Tab key |
| BackColor | The background color of the object |
| BestFit | True, to accept data that does not fit the mask exactly |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| ClipMode | Clip data and literals or clip data without literals |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| Enabled | True, to set the control to get focus and respond to UI |
| FixedPoint | True, to display zeros to the right of decimal place |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| IncDec | The decimal portion increment when using the button |
| IncInt | The integer portion increment when using the button |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | Action for invalid data when the control loses focus-show data, hide data, clear data |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| Mask | The edit mask for this control |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NoPrefix | The mode for the entry of the "&" character |
| NoSpecialKeys | Option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select the data in the control when it gets focus |
| OnFocusPosition | The position of the cursor in the data in the control when it gets focus |
| PromptChar | The character to indicate placeholder for data |
| PromptInclude | True, to include the prompt characters when the data is cut or copied |
| RequireFill | True, to require that all the characters be filled when the control loses focus |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideW idth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserEntry | Formatted or free format |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpMask1" WIDTH=187 HEIGHT=32
CLASSID="CLSID:1211A3D5-B48E-101C-933E-0000C005958C">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="3951">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="0">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="AllowOverflow" VALUE="0">
<PARAM NAME="BestFit" VALUE="0">
<PARAM NAME="ClipMode" VALUE="0">
<PARAM NAME="DataFormat" VALUE="27715">
<PARAM NAME="Mask" VALUE="###-##-####">
<PARAM NAME="PromptChar" VALUE="_">
<PARAM NAME="PromptInclude" VALUE="0">
<PARAM NAME="RequireFill" VALUE="0">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="NoPrefix" VALUE="0">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
<PARAM NAME="AutoTab" VALUE="0">
</OBJECT>
</BODY>
</HTML>
The fpMemo is a text data-entry ActiveX control. This control can be used to give the user the ability to enter and retrieve large amounts of text data. In database applications, you always need some text entry, such as description and comments. In some applications, you might need to display and get from the user a large amount of text data. This control is useful in such circumstances. This control can be bound to memo fields in the back-end database.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.8 : The fpMemo control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| Enabled | True, to set the control to get focus and respond to UI |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| LineLimit | The maximum number of lines allowed |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| NoSpecialKeys | The option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusNoSelect | False to select all the text in the control when this control gets focus |
| OnFocusPosition | The position of the cursor when this control gets focus |
| PageWidth | The width of the display page |
| ScrollBars | The type of scroll bars displayed |
| SelBackColor | The background color for the selected text |
| SelForeColor | The foreground color for the selected text |
| SelMode | The selection mode-normal, line, or extended |
| ShowEOL | Show the End-Of-Line character |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| WordWrap | True, to automatically wrap the lines |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpMemo1" WIDTH=187 HEIGHT=83
CLASSID="CLSID:A18D4665-91EF-101C-84A6-BA990A365A4E">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="3951">
<PARAM NAME="_ExtentY" VALUE="1764">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="1">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusNoSelect" VALUE="-1">
<PARAM NAME="OnFocusPosition" VALUE="3">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="fpMemo1">
<PARAM NAME="WordWrap" VALUE="-1">
<PARAM NAME="ShowEOL" VALUE="0">
<PARAM NAME="SelMode" VALUE="0">
<PARAM NAME="LineLimit" VALUE="2147483647">
<PARAM NAME="ScrollBars" VALUE="3">
<PARAM NAME="PageWidth" VALUE="0">
<PARAM NAME="SelBackColor" VALUE="-2147483635">
<PARAM NAME="SelForeColor" VALUE="-2147483634">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The fpText is a text data-entry ActiveX control. This control can be used to give the user the ability to enter and retrieve text data of length 255 characters or less.
Vendor Information:
FarPoint Technologies, Inc.Figure 14.9 : The fpText control
http://www.fpoint.com
133 Southcenter Court, Suite 1000
Morrisville, NC 27560
(800) 645-4551
(919) 460-7606
| Property | Description |
| AlignTextH | The horizontal alignment of the text |
| AlignTextV | The vertical alignment of the text |
| AllowNull | True, to allow the user the capability to leave this control blank |
| Appearance | The border look-flat, 3-D, and so on |
| AutoAdvance | True, to advance to the next control after pressing the Enter key |
| AutoBeep | True, to sound the beep on user error |
| AutoCase | The type of case conversion for display-none, upper, lower, proper |
| BackColor | The background color of the object |
| BorderColor | The object's border color |
| BorderDropShadow | The 3-D shadow for border-none, always, on focus |
| BorderDropShadowColor | The border 3-D shadow color |
| BorderDropShadowWidth | The border 3-D shadow width |
| BorderGrayAreaColor | The color of the gray area of the 3-D border |
| BorderStyle | The object's border style |
| BorderWidth | The object's border width |
| ButtonDefaultAction | True, to enable the default action for the spin button |
| ButtonDisable | True, to disable the buttons on the control |
| ButtonHide | True, to hide the buttons |
| ButtonIncrement | The value by which the button index will be increased or decreased |
| ButtonMax | The upper limit for the button index |
| ButtonMin | The lower limit for the button index |
| ButtonStyle | The style of the button-none, spin, slide, and so on |
| ButtonWidth | The width of the button |
| ButtonWrap | True, to reset the button index when it crosses the upper or lower limits |
| CaretInsert | The caret for the insert mode |
| CaretOverwrite | The overstrike mode caret |
| CharPositionLeft | The left index of the characters displayed |
| CharPositionRight | The right index of the characters displayed |
| CharValidationText | The valid characters allowed |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| ControlType | The control UI mode-normal, read-only, static, button edit |
| CurrentPosition | The position of the cursor |
| DataChanged | True, when the data is changed |
| DataField | The name of the bound column in the DataSource |
| DataSource | The source of the database to be bound to this control |
| Enabled | True, to set the control to get focus and respond to UI |
| Font | The font of the control caption |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| HideSelection | True, to highlight the selected characters even when the control loses focus |
| hWND | The handle for the window |
| ID | The name of the object/control |
| IncHoriz | The distance the cursor will be moved for slider button |
| InvalidColor | The background color when the data in the control is invalid |
| InvalidOption | Action for invalid data when the control loses focus-show data, hide data, clear data |
| IsNull | True, if the control value is null |
| IsValid | True, if the control contains a valid entry |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| MarginBottom | The bottom margin in pixels |
| MarginLeft | The left margin in pixels |
| MarginRight | The right margin in pixels |
| MarginTop | The top margin in pixels |
| MaxLength | The maximum number of characters allowed |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| MultiLine | True, to display the text in multiple lines |
| NoSpecialKeys | Option for handling keyboard keys |
| NullColor | The background color when the control contains no value |
| OnFocusAlignH | Horizontal alignment of the data in the control when it gets focus |
| OnFocusAlignV | Vertical alignment of the data in the control when it gets focus |
| OnFocusNoSelect | False, to select all the text in the control when this control gets focus |
| OnFocusPosition | The position of the cursor when this control gets focus |
| PasswordChar | The mask character to appear |
| ScrollV | True, to allow vertical scrolling |
| ReDraw | Repaint the control |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| ThreeDFrameColor | The color of the 3-D frame |
| ThreeDFrameWidth | The width of the 3-D frame |
| ThreeDInsideHighliteColor | The color for the inner border 3-D highlight |
| ThreeDInsideShadowColor | The color for the inner border 3-D shadow |
| ThreeDInsideStyle | The style for the inner border 3-D-none, lowered, raised |
| ThreeDInsideWidth | The width for the inner border 3-D |
| ThreeDOnFocusInvert | True, to invert the 3-D when the control gets focus |
| ThreeDOutsideHighliteColor | The color for the outer border 3-D highlight |
| ThreeDOutsideShadowColor | The color for the outer border 3-D shadow |
| ThreeDOutsideStyle | The style for the outer border 3-D-none, lowered, raised |
| ThreeDOutsideWidth | The width for the outer border 3-D |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserEntry | Formatted or free format |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| WordWrap | True, to automatically wrap the lines |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Event | Description |
| Advance | Triggers when a valid character is entered at the last position |
| ButtonHit | Triggers when a button is pressed by the user |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| ChangeMode | Triggers when the user changes the edit mode between insert and overstrike |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidData | Triggers when the control contains invalid data |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
| UserError | Triggers when an error occurs |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="fpText1" WIDTH=135 HEIGHT=32
CLASSID="CLSID:CDf3b180-D408-11CE-AE2C-0080C786E37D">
<PARAM NAME="_Version" VALUE="131072">
<PARAM NAME="_ExtentX" VALUE="2858">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="68">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="ForeColor" VALUE="-2147483640">
<PARAM NAME="ThreeDInsideStyle" VALUE="0">
<PARAM NAME="ThreeDInsideHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDInsideShadowColor" VALUE="-2147483642">
<PARAM NAME="ThreeDInsideWidth" VALUE="1">
<PARAM NAME="ThreeDOutsideStyle" VALUE="0">
<PARAM NAME="ThreeDOutsideHighlightColor" VALUE="-2147483628">
<PARAM NAME="ThreeDOutsideShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDOutsideWidth" VALUE="1">
<PARAM NAME="ThreeDFrameWidth" VALUE="0">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderWidth" VALUE="1">
<PARAM NAME="ButtonDisable" VALUE="0">
<PARAM NAME="ButtonHide" VALUE="0">
<PARAM NAME="ButtonIncrement" VALUE="1">
<PARAM NAME="ButtonMin" VALUE="0">
<PARAM NAME="ButtonMax" VALUE="100">
<PARAM NAME="ButtonStyle" VALUE="0">
<PARAM NAME="ButtonWidth" VALUE="0">
<PARAM NAME="ButtonWrap" VALUE="-1">
<PARAM NAME="ButtonDefaultAction" VALUE="-1">
<PARAM NAME="ThreeDText" VALUE="0">
<PARAM NAME="ThreeDTextHighlightColor" VALUE="-2147483633">
<PARAM NAME="ThreeDTextShadowColor" VALUE="-2147483632">
<PARAM NAME="ThreeDTextOffset" VALUE="1">
<PARAM NAME="AlignTextH" VALUE="0">
<PARAM NAME="AlignTextV" VALUE="0">
<PARAM NAME="AllowNull" VALUE="0">
<PARAM NAME="NoSpecialKeys" VALUE="0">
<PARAM NAME="AutoAdvance" VALUE="0">
<PARAM NAME="AutoBeep" VALUE="0">
<PARAM NAME="AutoCase" VALUE="0">
<PARAM NAME="CaretInsert" VALUE="0">
<PARAM NAME="CaretOverWrite" VALUE="3">
<PARAM NAME="UserEntry" VALUE="0">
<PARAM NAME="HideSelection" VALUE="-1">
<PARAM NAME="InvalidColor" VALUE="-2147483637">
<PARAM NAME="InvalidOption" VALUE="0">
<PARAM NAME="MarginLeft" VALUE="3">
<PARAM NAME="MarginTop" VALUE="3">
<PARAM NAME="MarginRight" VALUE="3">
<PARAM NAME="MarginBottom" VALUE="3">
<PARAM NAME="NullColor" VALUE="-2147483637">
<PARAM NAME="OnFocusAlignH" VALUE="0">
<PARAM NAME="OnFocusAlignV" VALUE="0">
<PARAM NAME="OnFocusNoSelect" VALUE="0">
<PARAM NAME="OnFocusPosition" VALUE="0">
<PARAM NAME="ControlType" VALUE="0">
<PARAM NAME="Text" VALUE="fpText1">
<PARAM NAME="CharValidationText" VALUE="">
<PARAM NAME="MaxLength" VALUE="255">
<PARAM NAME="MultiLine" VALUE="0">
<PARAM NAME="PasswordChar" VALUE="">
<PARAM NAME="IncHoriz" VALUE="0.25">
<PARAM NAME="BorderGrayAreaColor" VALUE="-2147483637">
<PARAM NAME="NoPrefix" VALUE="0">
<PARAM NAME="ScrollV" VALUE="0">
<PARAM NAME="ThreeDOnFocusInvert" VALUE="0">
<PARAM NAME="ThreeDFrameColor" VALUE="-2147483633">
<PARAM NAME="Appearance" VALUE="0">
<PARAM NAME="BorderDropShadow" VALUE="0">
<PARAM NAME="BorderDropShadowColor" VALUE="-2147483632">
<PARAM NAME="BorderDropShadowWidth" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The MhDateInput control is specifically aimed at date and time entry. This control has a lot of versatility and includes a built-in spin button for a user-friendly data input.
Vendor information:
MicroHelp, Inc.> Figure 14.10 : The MhDateInput control
http://www.microhelp.com
4211 J.V.L Industrial Park Drive, NE
Marietta, GA 30066
(800) 922-3383
(770) 516-1099
| Property | Description |
| Alignment | Alignment of the caption text |
| AllowBlank | True, to allow blank entries |
| AutoHScroll | True, to scroll automatically for entries that are longer than the control |
| BackColor | The background color of the object |
| BevelSize | The 3-D bevel size in points |
| BevelColor | The color for the 3-D bevel |
| BorderColor | The object's border color |
| BorderStyle | The object's border style |
| CaretColor | Color of the caret, the small current value pointer that points to the day number or month or year |
| CaretHeight | The height of the caret |
| CaretInterval | The blink interval for the caret |
| CaretStyle | The style of the caret |
| CaretVAlign | The vertical alignment of the caret |
| CaretVisible | True, to display the caret |
| CaretWidth | The width of the caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| DateFormat | The format of the date display-normal, Julian, verbose, verbose with weekday, and so on |
| Enabled | True, to set the control to get focus and respond to UI |
| FillColor | The background color |
| FocusSelect | True, to select the entries when the control gets focus |
| Font | The font for the date display |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Intent | The pixels between the date and the control border |
| Language | The language code to display the date |
| LanguageNumber | The language number to display the date |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| LightColor | The light color for the control |
| MaxDay,MaxMonth,MaxYear | The upper limit for day, month, and year |
| MinDay,MinMonth,MinYear | The lower limit for day, month, and year |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| ReadOnly | True, to make the control non-edit |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| ShadowColor | The color for the shadow |
| Spin | The position of the spin button-left or right |
| SpinChange | The delta or amount of change when the spin arrow is clicked |
| SpinDelay | The delay between the first click and start of the repeat |
| SpinSpeed | The delay between two consecutive spin activation |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| TextColor | The color of the date display |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Undo | Reverts to the last change made |
| Valignment | The vertical alignment-top, bottom, center |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Refresh | Repaints the control |
| Event | Description |
| AutoTerminate | Triggers when a valid character is entered at the last position |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| Click | Triggers when a control is clicked with the mouse; also triggers when the user selects a value in a multi-value control such as the list box |
| DblClick | Triggers when a control is double-clicked |
| InvalidEntry | Triggers when the control has a value outside the minimum to maximum range |
| InvalidSetText | Triggers when invalid text is pasted into the control |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="MhDateInput1" WIDTH=252 HEIGHT=32
CLASSID="CLSID:AFCBCE20-AAf2-11CE-85B2-00AA00575482">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="_ExtentX" VALUE="5339">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="77">
<PARAM NAME="BevelSize" VALUE="1">
<PARAM NAME="Text" VALUE="Wednesday, November 27, 1996">
<PARAM NAME="Spin" VALUE="2">
<PARAM NAME="AutoHScroll" VALUE="-1">
<PARAM NAME="FontStyle" VALUE="1">
<PARAM NAME="CaretStyle" VALUE="1">
<PARAM NAME="DateFormat" VALUE="3">
</OBJECT>
</BODY>
</HTML>
The MhInput control is a general purpose data input control. The main advantage of this control is the formatted input functionality, such as phone numbers, Social Security numbers, ZIP codes, and so on. You can add more formatted inputs like credit card numbers or ID numbers specific to your application.
Vendor information:
MicroHelp, Inc.Figure 14.11 : The MhInput control
http://www.microhelp.com
4211 J.V.L Industrial Park Drive, NE
Marietta, GA 30066
(800) 922-3383
(770) 516-1099
| Property | Description |
| _Text | The string value in the control |
| Alignment | Alignment of the text in the control |
| BackColor | The background color of the object |
| BorderStyle | The object's border style |
| CaretInsert | The caret type during the insert mode |
| CaretOverstrike | The caret type during the overstrike mode |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| DateFormat | The format of the date display-normal, Julian, verbose, verbose with weekday and so on |
| Enabled | True, to set the control to get focus and respond to UI |
| FieldType | Preformatted field type-phone number, ZIP code, Social Security, and so on |
| Font | The font for the text display |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Intent | The pixels between the text and the control border |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| Mask | The input mask for data entry |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| MultiLine | True, to allow multiple lines data entry |
| PassChar | The character mask that appears for password-type entries |
| Position | The current position of the caret |
| RejectEnter | True, to not pass a press of the Enter key (ASCII 13) to the control |
| ScrollBars | The scroll bar display-none, vertical, horizontal, both |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| TextDefault | The default text that appears when the control is initialized |
| TextLen | The maximum length of text allowed |
| TextRaw | The string without any of the formatting characters |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Undo | Reverses the last change made |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Wordwrap | True, to allow word wrap |
Table 14.29 Methods of the MhInput Control
| Method | Description |
| AboutBox | Displays the About dialog box |
| Refresh | Repaints the control |
| Event | Description |
| AutoTerminate | Triggers when a valid character is entered at the last position |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="MhInput1" WIDTH=97 HEIGHT=32
CLASSID="CLSID:16E88EE0-A62A-11CE-85B2-00AA00575482">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="_ExtentX" VALUE="2037">
<PARAM NAME="_ExtentY" VALUE="662">
<PARAM NAME="_StockProps" VALUE="77">
<PARAM NAME="FieldType" VALUE="1">
<PARAM NAME="Mask" VALUE="999 99 9999">
<PARAM NAME="Text" VALUE="123-45-6789">
<PARAM NAME="TextLen" VALUE="11">
<PARAM NAME="CaretInsert" VALUE="1">
<PARAM NAME="Indent" VALUE="0">
<PARAM NAME="TextDefault" VALUE=" - - ">
<PARAM NAME="TextRaw" VALUE="123456789">
</OBJECT>
</BODY>
</HTML>
There is a 50-character text limitation for this control.
The IntInput control is specifically aimed at numeric data entry. This control has a lot of versatility and includes a built-in spin button for a user-friendly data input.
Vendor information:
MicroHelp, Inc.Figure 14.12 : The IntInput control
http://www.microhelp.com
4211 J.V.L Industrial Park Drive, NE
Marietta, GA 30066
(800) 922-3383
(770) 516-1099
| Property | Description |
| Alignment | Alignment of the number |
| AutoHScroll | True, to scroll automatically for entries that are longer than the control |
| BackColor | The background color of the object |
| BevelSize | The 3-D bevel size in points |
| BevelStyle | The style of the bevel-lowered, raised, chiseled, and so on |
| BorderColor | The object's border color |
| BorderStyle | The object's border style |
| CaretColor | Color of the caret, the small current value pointer that points to the current digit |
| CaretHeight | Height of the caret |
| CaretInterval | The blink interval for the caret |
| CaretStyle | The style of the caret |
| CaretVAlign | The vertical alignment of the caret |
| CaretVisible | True, to display the caret |
| CaretWidth | The width of the caret |
| CodeBase | The origin of the control, including URL, file type, and version number |
| Enabled | True, to set the control to get focus and respond to UI |
| FillColor | The background color |
| FocusSelect | True, to select the entries when the control gets focus |
| Font | The font for the date display |
| FontStyle | The style of the font-none, raised, raised with more shading, lowered, lowered with more shading |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Intent | The pixels between the date and the control border |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| LightColor | The light color for the control |
| Max | The upper limit for the number |
| Min | The lower limit for the number |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer displayed when the mouse is moved over the object |
| ReadOnly | True, to make the control non-editable |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| ShadowColor | The color for the shadow |
| Spin | The position of the spin button-left or right |
| SpinChange | The delta or the amount of change when the spin arrow is clicked |
| SpinDelay | The delay between the first click and start of the repeat |
| SpinSpeed | The delay between two consecutive spin activations |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| TextColor | The color of the date display |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Undo | Reverses the last change made |
| VAlignment | The vertical alignment-top, bottom, center |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Refresh | Repaints the control |
| Event | Description |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidEntry | Triggers when the control has a value outside the minimum to maximum range |
| InvalidSetText | Triggers when an invalid text is pasted into the control |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, orfunction key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="MhIntInput1" WIDTH=100 HEIGHT=50
CLASSID="CLSID:02B97C10-ED1E-11CD-A08B-00AA00575482">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="_ExtentX" VALUE="2117">
<PARAM NAME="_ExtentY" VALUE="1058">
<PARAM NAME="_StockProps" VALUE="77">
<PARAM NAME="BevelSize" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483640">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="Max" VALUE="100">
<PARAM NAME="Min" VALUE="0">
<PARAM NAME="Spin" VALUE="1">
<PARAM NAME="AutoHScroll" VALUE="1">
<PARAM NAME="FontStyle" VALUE="1">
<PARAM NAME="CaretColor" VALUE="-2147483642">
<PARAM NAME="CaretStyle" VALUE="2">
</OBJECT>
</BODY>
</HTML>
The MhMaskedInput control is aimed at text entry with specific formats. This control has a lot of versatility and can be used for a user-friendly data input.
Vendor information:
MicroHelp, Inc.Figure 14.13 : The MhMaskedInput control
http://www.microhelp.com
4211 J.V.L Industrial Park Drive, NE
Marietta, GA 30066
(800) 922-3383
(770) 516-1099
| Property | Description |
| Alignment | Alignment of the caption text |
| AutoHScroll | True, to scroll automatically for entries that are longer than the control |
| BackColor | The background color of the object |
| BevelSize | The 3-D bevel size in points |
| BevelStyle | The style of the 3-D bevel |
| BorderColor | The object's border color |
| BorderStyle | The object's border style |
| CaretColor | The color of the caret, the small current value pointer |
| CaretHeight | The height of the caret |
| CaretInterval | The blink interval for the caret |
| CaretStyle | The style of the caret |
| CaretVAlign | The vertical alignment of the caret |
| CaretVisible | True, to display the caret |
| CaretWidth | The width of the caret |
| Case | The case conversion of the input value-mixed, upper, lower, proper |
| CMask | The custom mask |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| Enabled | True, to set the control to get focus and respond to UI |
| FillColor | The background color |
| FocusSelect | True, to select the entries when the control gets focus |
| Font | The font for the date display |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Intent | The pixels between the date and the control border |
| INIFile | The INI file where the settings for this control are kept |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| LightColor | The light color for the control |
| Mask | The input mask for the text entry |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| ReadOnly | True, to make the control non-editable |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| ShadowColor | The color for the shadow |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The date in the text format |
| TextColor | The color of the date display |
| TextDefault | The default text displayed when the control is initialized |
| TextLength | The maximum length of the text entry |
| TextRaw | The entered text without and formatting characters and conversion |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Undo | Reverses the last change made |
| Valignment | The vertical alignment-top, bottom, center |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Refresh | Repaints the control |
| Event | Description |
| AutoTerminate | Triggers when a valid character is entered at the last position |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidEntry | Triggers when the control has an invalid entry |
| InvalidSetText | Triggers when an invalid text is pasted into the control |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="MhMaskInput1" WIDTH=135 HEIGHT=43
CLASSID="CLSID:39540F00-f4f8-11CE-86BA-00AA00A25549">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="_ExtentX" VALUE="2858">
<PARAM NAME="_ExtentY" VALUE="917">
<PARAM NAME="_StockProps" VALUE="77">
<PARAM NAME="BevelSize" VALUE="2">
<PARAM NAME="BevelStyle" VALUE="2">
<PARAM NAME="BorderColor" VALUE="-2147483642">
<PARAM NAME="BorderStyle" VALUE="2">
<PARAM NAME="FillColor" VALUE="-2147483633">
<PARAM NAME="LightColor" VALUE="-2147483628">
<PARAM NAME="ShadowColor" VALUE="-2147483632">
<PARAM NAME="TextColor" VALUE="-2147483630">
<PARAM NAME="Text" VALUE="MhMaskInput1">
<PARAM NAME="Indent" VALUE="2">
<PARAM NAME="AutoHScroll" VALUE="-1">
<PARAM NAME="CaretColor" VALUE="-2147483642">
<PARAM NAME="CaretVisible" VALUE="-1">
<PARAM NAME="VAlignment" VALUE="0">
<PARAM NAME="INIFile" VALUE="mhmask.ini">
<PARAM NAME="CharMaskMax" VALUE="-1">
<PARAM NAME="CaseProperMax" VALUE="-1">
</OBJECT>
</BODY>
</HTML>
This control can also be used with mixed-case formatting.
The MhRealInput control is specifically aimed at numeric data entry. This control has a lot of versatility and includes a built-in spin button for a user-friendly data input.
Vendor information:
MicroHelp, Inc.Figure 14.14 : The MhRealInput control
http://www.microhelp.com
4211 J.V.L Industrial Park Drive, NE
Marietta, GA 30066
(800) 922-3383
(770) 516-1099
| Property | Description |
| Alignment | Alignment of the number |
| AutoHScroll | True, to scroll automatically for entries that are longer than the control |
| BackColor | The background color of the object |
| BevelSize | The 3-D bevel size in points |
| BevelStyle | The style of the bevel-lowered, raised, chiseled, and so on |
| BorderColor | The object's border color |
| BorderStyle | The object's border style |
| CaretColor | The color of the caret, the small current value pointer that points to the current digit |
| CaretHeight | The height of the caret |
| CaretInterval | The blink interval for the caret |
| CaretStyle | The style of the caret |
| CaretVAlign | The vertical alignment of the caret |
| CaretVisible | True, to display the caret |
| CaretWidth | The width of the caret |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| DecimalPlaces | The number of decimal places |
| Enabled | True, to set the control to get focus and respond to UI |
| FillColor | The background color |
| FocusSelect | True, to select the entries when the control gets focus |
| Font | The font for the number display |
| FontStyle | The style of the font-none, raised, raised with more shading, lowered, lowered with more shading |
| ForeColor | The foreground color of the object |
| Height | The vertical height of the object |
| hWND | The handle for the window |
| ID | The name of the object/control |
| Intent | The pixels between the date and the control border |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| LightColor | The light color for the control |
| MaxReal | The upper limit for the number |
| MinReal | The lower limit for the number |
| MoneyFormat | True, to set the currency format |
| MouseIcon | The image that appears when the mouse is moved over the object |
| MousePointer | The mouse pointer that appears when the mouse is moved over the object |
| ReadOnly | True, to make the control non-edit |
| SelLength | The number of characters selected |
| SelStart | The starting/insertion point of selection |
| SelText | The character string selected by the user |
| Separator | The separator character, usually "," |
| ShadowColor | The color for the shadow |
| Spin | The position of the spin button-left or right |
| SpinChangeReal | The delta or the amount of change when the spin arrow is clicked |
| SpinDelay | The delay between the first click and start of the repeat |
| SpinSpeed | The delay between two consecutive spin activations |
| TabIndex | The object's tab order position in the HTML layout |
| Text | The number in the text format |
| TextColor | The color of the number display |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| Undo | Reverses the last change made |
| VAlignment | The vertical alignment-top, bottom, center |
| ValueReal | The number in the control |
| Visible | False, to hide the control |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| Refresh | Repaints the control |
| Event | Description |
| Change | Triggers when the value of a control changes by either the UI or programmatically; use this event handler to synchronize data between controls |
| Click | Triggers when a control is clicked with the mouse |
| DblClick | Triggers when a control is double-clicked |
| InvalidEntry | Triggers when the control has a value outside the minimum to maximum range |
| InvalidSetText | Triggers when an invalid text is pasted into the control |
| KeyDown | Triggers when a user presses a control, navigation, or function key |
| KeyPress | Triggers when a key is either pressed by the user or sent from the SendKeys function |
| KeyUp | Triggers when a user releases a control, navigation, or function key |
| MouseDown | Triggers when a user presses a mouse button |
| MouseMove | Triggers when the user moves the mouse |
| MouseUp | Triggers when a user releases a mouse button |
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="MhRealInput1" WIDTH=100 HEIGHT=32
CLASSID="CLSID:0f1f1505-C40A-101B-AD04-00AA00575482">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="_ExtentX" VALUE="2117">
<PARAM NAME="_ExtentY" VALUE="670">
<PARAM NAME="_StockProps" VALUE="77">
<PARAM NAME="BevelStyle" VALUE="3">
<PARAM NAME="Text" VALUE="10000.000000">
<PARAM NAME="MaxReal" VALUE="10000">
<PARAM NAME="MinReal" VALUE="0">
<PARAM NAME="Spin" VALUE="2">
<PARAM NAME="CaretColor" VALUE="-2147483642">
<PARAM NAME="MoneyFormat" VALUE="-1">
</OBJECT>
</BODY>
</HTML>
A good control for quantity and currency inputs.
The Crystal Report Engine gives you the flexibility to add ad hoc reporting capability to your applications. The reporting can be as simple as point-and-shoot printed reports or as complex as a fully user-configurable online report viewer.
Vendor Information;
Seagate Software Information Management Group, Inc.This is a back-end ActiveX control and, hence, has no GUI.
http://www.img.seagatesoftware.com
3873 Airport Way, P.O. Box 9754,
Bellingham, WA USA 98227-9754
(800) 663-1244
(604) 681-2934
| Property | Description |
| BoundReportFooter | The footer for the report |
| BoundReportHeading | The heading for the report |
| CodeBase | The origin of the control, including the URL, file type, and version number |
| Connect | Connects to the data source |
| CopiesToPrinter | The number of copies when the destination is printer |
| DataFiles | An array containing the data source file names |
| DataSource | The bound data control |
| Destination | The destination of the report-To Window, To Printer, |
| To File | |
| Formulas | An array containing the formulas used in the reports |
| GroupSelectionFormula | A formula to limit the group of records included in the report |
| GroupSortFields | The sort fields |
| LastErrorNumber | The error number of the last error encountered |
| Height | The vertical height of the object |
| ID | The name of the object/control |
| Left | The distance between the left edge of the control and the left edge of the HTML layout |
| PrintFileName | The file name when the destination is a file |
| PrintFileType | Record, Tab Separated, DIF, CSV, and so on |
| ReportFileName | The name of the report definition file |
| ReportSource | The source for the report; selected files as defined in the report definition file or all files in the data source |
| SelectionFormula | The record selection formula |
| Top | The distance between the top edge of the control and the top edge of the HTML layout |
| UserName | The user name for access database |
| Width | The width of the control in points |
| Method | Description |
| AboutBox | Displays the About dialog box |
| PrintReport | Prints the report control |
There are no events for the Crystal Report Engine.
<HTML>
<HEAD>
<TITLE>New Page</TITLE>
</HEAD>
<BODY>
<OBJECT ID="CrystalReport1" WIDTH=28 HEIGHT=28
CLASSID="CLSID:00025601-0000-0000-C000-000000000046">
<PARAM NAME="_ExtentX" VALUE="593">
<PARAM NAME="_ExtentY" VALUE="593">
<PARAM NAME="_StockProps" VALUE="0">
<PARAM NAME="ReportFileName" VALUE="">
<PARAM NAME="Destination" VALUE="0">
<PARAM NAME="WindowLeft" VALUE="100">
<PARAM NAME="WindowTop" VALUE="100">
<PARAM NAME="WindowWidth" VALUE="490">
<PARAM NAME="WindowHeight" VALUE="300">
<PARAM NAME="WindowTitle" VALUE="">
<PARAM NAME="WindowBorderStyle" VALUE="2">
<PARAM NAME="WindowControlBox" VALUE="-1">
<PARAM NAME="WindowMaxButton" VALUE="-1">
<PARAM NAME="WindowMinButton" VALUE="-1">
<PARAM NAME="CopiesToPrinter" VALUE="1">
<PARAM NAME="PrintFileName" VALUE="">
<PARAM NAME="PrintFileType" VALUE="0">
<PARAM NAME="SelectionFormula" VALUE="">
<PARAM NAME="GroupSelectionFormula" VALUE="">
<PARAM NAME="Connect" VALUE="">
<PARAM NAME="UserName" VALUE="">
<PARAM NAME="ReportSource" VALUE="0">
<PARAM NAME="BoundReportHeading" VALUE="">
<PARAM NAME="BoundReportFooter" VALUE="0">
</OBJECT>
</BODY>
</HTML>
The Crystal Report Engine is part of a group of products from Seagate Software aimed at flexible reporting and querying functions. The products are positioned as workgroup-decision support applications and are rightfully so.
Another related product from Seagate Software is the CrystalINFO, which has all the features required to design, develop, and deploy report (online, offline, or both) generating client/server applications. Because it can connect to a variety of databases, including MS SQL Server, Sybase, Oracle, and Btrieve, the CrystalINFO product can be used to access data from legacy and other applications.