Setting Grid Control Properties

Select each field in the Selected Fields list to display its Field Properties menu. There are many optional properties for each field's control. The default values for these properties produce a useable starting configuration for your grid. This means that you can largely ignore these optional properties when you are learning to build grids or you expect to gradually refine your design in later revisions.

Note : It is not possible to display a default value for a field in a grid's new record row. However, you can insert a default value if the user leaves the field blank by inserting a script into the grid's BeforeValidateNewRecords event.

Property Menu Options

Right clicking on the white space of a property menu lists a set of display options (V7). [Picture]

Categorized - displays menu options in groups, as illustrated above
Alphabetical - displays all menu options in a single alphabetized group
Toolbar visible - displays buttons that switch between Categorized and Alphabetical display modes
Help visible - displays help for the currently selected property at the bottom of the property menu

Select the Control Type

If your grid is read only, then fields that you put on the grid will be displayed by default in label controls. If the grid is updateable, then the fields will be displayed in textbox controls. For some data types, such as images and dates, you will have to manually select the control type ( Display Settings > Control Type ).

The initial Control type for fields that display character data will be "label" for a read only grid and "text" for an editable grid. A label control simply displays the value of the field without any control over its width. For this reason, you may want to change the value to "textbox", which always has a specified character width, even if you intend for the field to be read only.

The types of controls that you can place on a grid are:

Version 6

Label - a read-only control suitable for character, numeric, and date/time data
Text box - an editable control suitable for character, numeric, and date/time data
Check box - allowing a selection from a list of values
Drop Down Box - a list box that may appear as a list or combo box, and allowing a selection from an existing list of values, which is hard coded or retrieved from a table
Image - displaying either embedded or linked images
Link - a hyperlink, which may open another page or select a record to display
Radio button - allowing a selection from a list of values
Text area - similar to a text box, but with multiple lines
Date picker - a variation on a text box that is available if your grid is updateable

Version 7

Calendar - a monthly calendar
Custom - where you define the data to display and its formatting using Xbasic and HTML
Freeform - where you can place one or more other defined fields along with HTML coding
Hidden - hides the control without hiding its column
Lookup - a variation on a textbox or textarea control that retrieves one or more field values from another grid
Tab Control - a control that allows you to selectively display and hide other controls

Allowed Control Types

Purpose	Action
Date field	To create a control appropriate for s a date, set the control type to"calendar" or "textbox" and then modify Date picker properties.
Image or image reference field	To create a field that displays a picture, set the control type to "Image".
Rich Text Formatted (RTF) text	RTF Memo fields are not editable and must be displayed as Labels.
Detail view link	Set the control type of the field the that connects to the detail view to type "link".
True/False choice	Set the control type of the field to check box and define its Choice properties.
Short list of choices	Set the control type of the field to radio button and define its Choice properties. Choices can be static or dynamic (retrieved from a table).
Long list of choices	Set the control type of the field to drop down list box and define its Choice properties. Choices can be static or dynamic (retrieved from a table).

Select the appropriate display format

If the control type is Label, Link, TextBox, or TextArea, the Display Format property allows you to automatically change the presentation of your data. For example, a money value could be displayed with its currency symbol and commas, and with the correct number of decimal characters.

An In-Line style overrides the formatting of the cascading style sheet. If you wanted the text to be bolded, or in a different font, point size, or color, this is where you would define the formatting.

You may want to allow only certain users to see a field. To do this set a minimum user security level required before the field will display (V7).

You may want to allow the user to see the fields in a grid, but not edit, delete, or insert records. To do this, set three different permission properties that control grid update (V7).

You may also want to define validation rules to improve the quality of user input (V7).

Display Settings
Category	Options and Description
Control type	V6	Sets the type of the control. "AdvancedButton" "CheckBox" "Custom" "DropDownBox" "Image" "Label" "Link" "RadioButton" "TextArea" "TextBox"
Control type	V7	"Hidden" tmpl.Field_Info[N] .controltype as C
Display Format	V6	This expression formats the data after it has been entered into the field. Click to display the Display Format dialog box. This property should be set to one of the following values: Null (empty) An Xbasic expression that returns a character value. The expression should use <value> as Placeholder for the field value, as in the following example: f_upper(<value>). Optionally, click Select Pre-Defined Format to select a format from the Pre-Defined Formats dialog box. Note : There are no predefined display formats for short time (Y) fields. However, you can write your own. tmpl.Field_Info[N] .DisplayFormat as C Note : If the control type is "TextBox" and the field type is "Date", then a Date Picker will appear. You must set the tmpl.Field_Info[N].DatePicker.DateFormat to the same style. See Date Picker DateFormat.
Display unformat	V6	If you set a Display Format, you may also place a character expression in the this field. This expression reformats the data before it is stored in the database. tmpl.Field_Info[N] .DisplayUnFormat as C
Validation Rules	V7	Validation rules define how to respond to user input into an editable field. Refer to Setting Web Control Validation Rules.

Set Column or Row Properties

There are situations where you will want to hide a column or row. This will be true if you are placing the field in a different column or row using a Freeform template. A freeform layout allows to insert any HTML code plus any combination of fields on the grid into a grid column. For example, although your database had firstname and lastname fields, a freeform layout could display a single name field that combined these two values.

In almost all cases you will want to define the column or row heading.

If you want to control access to this field, you may set a minimum security level requirement (V7). A users with a too low security level will not be able to see the column.

The column's cell in-line style field defines additional HTML formatting that you want to apply to the cell of the grid. If you wanted to change the border or background of the cell, this is where you would do it.

The can sort property enables and disables the ability to click on the column heading and sort the current page based on the values in the selected column.

Column and Row Properties
Category	Options and Description
Hide column, Hide row	V6	Hides the column or row that would contain this field. You might choose to hide the field if it was displayed in a free-form layout. tmpl.Field_Info[N] .Column.Hide as L
Column heading, Row heading	V6	The label that identifies the column o row. tmpl.Field_Info[N] .Column.Heading as C
Column in-line style, Row label in-line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .Column.LabelInLineStyle as C
Heading prefix, Label prefix	V6	Specify HTML text or the path to and name of an image to be displayed to the left of the row or above the column heading. tmpl.Field_Info[N] .Column.Heading_Left as C
Row label position	V6	The position of the label in relationship to the control. The options are: "Left" "Right" "Above" "Below" tmpl.Field_Info[N] .Column.LabelPosition as C
Can sort	V6	Specifies whether the grid will be sorted when the user clicks on the column or row heading. tmpl.Field_Info[N] .Column.Sort as C
Sort field	V6	Specify the field(s) to sort on when user clicks on the column or row title. Put commas between field names. tmpl.Field_Info[N] .Column.Sort as C
Freeform layout	V6	Specify if this column or row should display just this field, or allow a free-form layout. The options are: "Freeform" tmpl.Field_Info[N] .Column.Type as C
Freeform template	V6	Click to display the Freeform Column Layout dialog box to define the fields and formats to display in this grid cell. tmpl.Field_Info[N] .Column.FreeFormTemplate = <<%html% ' code here %html%
Cell in-line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .Column.InLineStyle as C
Security level	V7	If the user is logged in with a security level that is lower than the security level you specify here, the column or row will be hidden. Set the security level to 0 to always show this column or row. tmpl.Field_Info[N] .Column.SecurityLevel as N
Style label if error	V6	Specify if the label should be styled if a validation error occurs (V6 only). tmpl.Field_Info[N] .Column.StyleLabelIfFieldError as L
Label in-line error style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details (V6 only). tmpl.Field_Info[N] .Column.ErrorLabelInLineStyle as C
Bubble Help Text	V8	Optionally, set an initial value for the control to display. tmpl.Variable_Info[N] .BubbleHelp as C
Label Bubble Help Text	V8	Optionally, set an initial value for the control to display. tmpl.Variable_Info[N] .BubbleHelpLabel as C
Break Type	V8	Forces a new row either before or after a control. The options are: "None" "Break before" "Break after" "Break before and after" tmpl.Variable_Info[N] .Breaktype as C
Column Span	V8	The number of columns to group together.. tmpl.Variable_Info[N] .nCols as N

Set Update Properties

If the grid is editable and the control type is editable, you may optionally suppress editing of the field that you view through the control.

You may also set a minimum security level required to change the field's contents (V7).

Update Properties
Category	Options and Description
Updateable	V6	Specifies whether the field can be edited . with tmpl.field_info[N] .Updateable as L
Table alias	V6	This property defines the alias of the table that contains the field. with tmpl.field_info[N] .Table_Alias as C
Field to update	V6	Specifies the field that binds to the control. with tmpl.field_info[N] .FieldToUpdate as C
Security level	V7	Specifies the minimum security level required to edit the contents of the field. with tmpl.field_info[N] .UpdateSecurityLevel as N

Calendar Properties

The Calendar control (V7) is a control that a user can place on Grid and Dialog components. Compare it to the date picker control, which is a text box with a button that opens a calendar in a pop-up window. The Calendar control always displays the calendar on the page. The user does not have to click a button to open the calendar in a new window. The Calendar control can be read-only or set the value of table field.

Note : Version 7 allows the user's grid and the server hosting the Application Server to use different date formats. This feature was added to resolve the problem where the server was using a US style date format (dd/mm/yy), but the application needed to use a date format such as yy-mm-dd or yy/mm/dd. In the Grid Component Builder set Grid Properties > Advanced > Date format on client does not match server to TRUE and enter the client date format in the following field. You may use different separators between the YY, MM, and DD parts of the date format. This property informs the Application Server that it needs to translate dates entered through this grid component.

Calendar Properties
Category	Options and Description
Date format	V7	Specify the format in which date values are passed to the calendar control. e.g. mm/dd/yyyy. with tmpl.field_info[N] .Calendar.DateFormat as C
Read only	V7	Specify if the calendar control is for displaying date values only, or should it allow the user to also set date values. If the calendar control is read only, then the user cannot click on any of the days, and the buttons at the top of the control to change the year and month are hidden. with tmpl.field_info[N] .Calendar.Readonly as L
Switch year	V7	This property is available on if the Read only property is not set. If a date value has a two digit year, specify which year to switch from 1900 to 2000. with tmpl.field_info[N] .CalendarSwitchYear as N
Combo boxes	V7	When enabled, displays the combo boxes for the year and month pickers. with tmpl.field_info[N] .Calendar.UseComboBoxes as L
Low year	V7	Specifies the low year in the year picker. with tmpl.field_info[N] .Calendar.LowYear as N
High year	V7	Specifies the high year in the year picker. with tmpl.field_info[N] .Calendar.HighYear as N

A columnar grid with a calendar control. [Picture]

Custom Control Properties

The Custom control (V7) is a control where the data contents and formatting of a column (or row) is defined by your Xbasic and HTML code. A custom control can reference a number of grid component and data variables, including the value of data in other grid cells. A custom control can create its own variables to carry values between cells of the grid.

A custom control must contain valid HTML code. This means, for example, that row-by-row, the type of web control that appears in a grid cell could vary from label to textbox to drop down listbox.

Note : Custom controls cannot be used for data entry to bound table fields.

Custom Control Properties

Category

Options and Description

Definition

Specifies the Xbasic and HTML code that generates the contents of the field.

with tmpl.field_info[N]

.CustomControlXbasic as C

A custom control where Xbasic dynamically sets font and background properties, depending on whether the quantity value is above or below the average. [Picture]

In the following example, the field name is Quantity. as a result, the function is named Quantity_Render().

function QUANTITY_render as c (data as p, args as p, session as p)

on error goto xbasicError

if data.quantity > args.summary.quantity.average then

QUANTITY_render = <<%html%

<div style="color: #000000; text-align: right;background-color:#00ff00;font-weight:bold;">%html% + data.quantity + "</div>"

else

QUANTITY_render = <<%html%

<div style="color: #ffffff; text-align: right;background-color:#ff0000;font-weight:bold;">%html% + data.quantity + "</div>"

end if

end

xbasicError:

QUANTITY_render = "Error in custom control xbasic: " + error_text_get()

end function

In this example, the if and else clauses have similar content. Both are character strings that combine HTML coding and a reference to the quantity field, using the prefix " data. ". Although not a required technique, embedding the HTML inside the <div> ... </div> tags simplifies the coding. Likewise, embedding the <div> tag inside the <<%html% ... %html string simplifies the coding by removing the requirement to escape special characters.

CheckBox Properties

Check boxes are appropriate when you want to set a True/False value into a logical field. The most important property for a check box control is the definition of its choices.

Check box Properties
Category	Options and Description
Choices	V6	Click to define the true and false choices set by the check box. Refer to Defining Choices for Check Boxes, Radio Buttons, and Drop Down Lists for details.
Orientation	V6	The orientation of the label. The choices are: "Horizontal" "Vertical" with tmpl.field_info[N] .CheckBox.Orientation as C
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. with tmpl.field_info[N] .CheckBox.InLineStyle as C
Not in list rule	V6	Specifies the value to set if the user input does not match a specified choice. The options are: "First Entry" - use the first entry in the list "Null" - set the field to NULL "Do Nothing" - accept the user input with tmpl.field_info[N] .CheckBox.NotInListRule as C
Style control if error	V6	Specifies whether to apply a second style to the field if a validation error occurs (V6 only). with tmpl.field_info[N] .CheckBox.StyleFieldIfError as L
In – line style for errors	V6	Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6 only). with tmpl.field_info[N] .CheckBox.ErrorInLineStyle as C

Date Picker Properties

A date picker is a variation on a TextBox control. The date picker option appears in a TextBox control if the grid is updateable.

Note : Pop-up blockers will prevent the Calendar Picker from appearing and will sometimes generate an error message.

Date Picker Properties
Category	Options and Description
Date format	V6	Refer to Date and Time Format Elements for supported formats. with tmpl.field_info[N] .DatePicker.DateFormat as C
Date picker icon	V6	Selects the icon that appears to the right of the field. The options are: 1 = 2 = 3 = 4 = 5 = 6 = with tmpl.field_info[N] DatePicker.IconNumber as N
Switch year	V6	The number that is used to place 2 year dates into the current or prior century. with tmpl.field_info[N] .DatePicker.SwitchYear as N
Use combo boxes	V6	Enables or disables the month and year combo boxes. with tmpl.field_info[N] .DatePicker.UseComboBoxes as L
Low year	V6	The lowest number year shown in the year list box. with tmpl.field_info[N] .DatePicker.LowYear as N
High year	V6	The highest number year shown in the year list box. with tmpl.field_info[N] .DatePicker.HighYear as N

The Calendar control appears when the user clicks the calendar icon to the right of the date field. [Picture]

The size of the pop-up calendar of the date picker is defined in a JavaScript file named a5_html_calendar.js. To change the size of the calendar modify the pixel offset values associated with offsetWidth (30) and offsetHeight (40) in the following line in this file.

'<body class="'+style+'PAGEBODY" onload="fill_calendar('+old_month+', '+old_year+', settings, '+month_type+', '+day_type+'); window.resizeTo(document.getElementById(\'cal_layout_table\').offsetWidth+ 30 , document.getElementById(\'cal_layout_table\').offsetHeight+ 40 )" style="margin:0px; overflow: hidden;">\n'+

DropDownBox Properties

DropDownBoxes are appropriate when you want to select a value from a large list of alternatives. The most important properties for a dropdownbox control is the definition of its choices and its height. A height of 1 produces a combo box. A height greater than 1 produces a list box.

Note : When you allow the user to select multiple values, the control returns an array. To convert an array to a character value, you need to use an expression like the following.

TargetVariable = crlf_to_comma(ControlName.dump()

Note : DropDownBoxes do not allow the user to enter new values.

If you set the height to be more than 1 line, you can also set the multi-select allowed field to "Multiple". This allows the user to select more than one value to insert into the field. (Commas will separate the resulting selections.)

Drop Down Box Properties
Category	Options and Description
Choices	V6	Defines the choices the appear in the control. Click to define the true and false Choices set by the check box. Refer to Defining Choices for Check Boxes, Radio Buttons, and Drop Down Lists for details.
Height	V6	Set the height of the label in lines. The default is 1, which produces a combo box. Values larger than 1 produce a list box. with tmpl.field_info[N] .DropdownBox.Size as N
Multi-select allowed	V6	Defines whether the user can select more than one value from the list. The options are: "Single" "Multiple" with tmpl.field_info[N] .DropdownBox.selectStyle as C
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. with tmpl.field_info[N] .DropdownBox.InLineStyle as C
Not in list rule	V6	Specifies the value to display if the list contains a value not coded in the page. The options are: "Add to list" - display the value "Do Nothing" - show the first value in the list with tmpl.field_info[N] .DropdownBox.NotInListRule as C
Style control if error	V6	Specifies whether to apply a second style to the field if a validation error occurs (V6 only). with tmpl.field_info[N] .DropdownBox.StyleFieldIfError as L
In – line style for errors	V6	Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6 only). with tmpl.field_info[N] .DropdownBox.ErrorInLineStyle as C

Drop down list, radio button, and check box controls. Dropdown list controls optionally allow multiple selections. [Picture]

Image Properties

Note : For more information about using image files as Links, see Using Images in Link Fields.

Image Properties
Category	Options and Description
Image name	V6	The name of the image to display. tmpl.Field_Info[N] .Image.Imagename as C
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .Image.InLineStyle as C
Text description	V6	The text description of the image. tmpl.Field_Info[N] .Image.Alt as C
Is Hyperlink	V6	Is the image a hyperlink? tmpl.Field_Info[N] .Image.IsHyperLink as L
Hyperlink target	V6	The page to display when the link is clicked. tmpl.Field_Info[N] .Image.hyperlinkTarget as C
Target frame	V6	The name of the window that will display the new page. tmpl.Field_Info[N] .Image.hyperlinkTargetFrame as C
Image path	V6	For image file references: the folder where the images are stored. tmpl.Field_Info[N] .Image.ImagePath as C

Label Properties

Category

Options and Description

In – line style

Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details.

tmpl.Field_Info[N]

.Label.InLineStyle as C

Link Properties

An essential decision about a link control is what it will display. The options are:

Value in field
Value from other field(s)
Static text
Static image
Image in another control

Link controls have choices for the Link address type. The link could be:

a URL (presumably also a field value)
an email address (presumably also a field value)
a link to the detail view form
a value that is computed (see Link Address Builder )
a value that specifies filter, order, and/or linking information for the records in a second grid

Link Properties
Category	Options and Description
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. with tmpl.field_info[N] .link.InLineStyle as C
Display what in link?	V6	Specifies what is displayed in the link. The options are: "Value in field" "Value from other field(s)" "Static text" "Static image" "Image in another control" with tmpl.field_info[N] .link.DisplayType as C
Field(s) to display	V6	Specify the HTML to display in the link. Use field placeholders to include values from other fields in the grid. Typically, the fields that you reference will have the Hide row or Hide column properties checked. with tmpl.field_info[N] .link.DisplayExpression as C
Static text	V6	Specify the text to display in the link. with tmpl.field_info[N] .StaticText as C
Static image	V6	Specify the image to display in the link. with tmpl.field_info[N] .StaticImage as C
Dynamic image control	V6	Specify the control that contains the image to display. with tmpl.field_info[N] .link.AlternateImageControl
Link address type	V6	Information about how to process the link information. "Field value in link address" "Field value is an email address" "DetailView link" "Computed from fields in the grid" with tmpl.field_info[N] .Link.Type as C
Link Address	V6	When the Link address type is "Computed from fields in the grid", this field appears. Click to define the link address in the Link Address Builder. with tmpl.field_info[N] .link.ComputedAddress
Target frame or window	V6	The default is "Explicit". Defines where to display the linked page. The default is Null. The options are: Blank (opens in a new window) "Explicit" "WindowName" (e.g. "Window2") "_blank" "_parent" "_self" "_search" "_top" tmpl.Field_Info[N] .Link.targetFrameOrWindow as C
Clear Parameters	V6	The default is .F. . Specifies whether the target URL preserves existing parameters. tmpl.Field_Info[N] . Link.ClearParameters as L
Scroll to Detail View	V6	The default is .T. . Specifies that the page should scroll down to display the detail view form when a record is selected. tmpl.Field_Info[N] .Link.ScrollToDetailView as L

An example of a displaying multiple field values as a link expression [Picture]

Lookup Properties

The Lookup property (V7) allows you retrieve one or more field values from another grid. For more information about lookup windows, refer to Defining Lookups for Text Boxes.

Lookup Properties
Category	Options and Description
Lookup	V7	When checked, makes the Textbox or Textarea control able to open a secondary lookup grid and retrieve field values. tmpl.Field_Info[N] .HasLookup as L
Lookup definition	V7	Specifies lookup grid to use, field mappings, and other properties of the lookup window.
Grid name	V7	Specifies the name of the grid to display in the lookup window. tmpl.Field_Info[N] .Lookup.GridName as C
Window title	V7	Specifies the title of the lookup window. tmpl.Field_Info[N] .Lookup.WindowTitle as C
Width	V7	Sets the width of the lookup window in pixels. tmpl.Field_Info[N] .Lookup.WindowWidth as N
Height	V7	Sets the height of the lookup window in pixels. tmpl.Field_Info[N] .Lookup.WindowHeight as N
Scrollbars	V7	Enables and disables scrollbars in the lookup window. tmpl.Field_Info[N] .Lookup.HasScrollBars as L
Resizable	V7	Enables or disables resizing of the lookup window. tmpl.Field_Info[N] .Lookup.IsResizeable as L
Inherit parent style	V7	Specifies whether to use its style sheet or inherit the style sheet of the parent page. tmpl.Field_Info[N] .Lookup.LookupWindowInheritParentStyle as L
Select record link label	V7	Specifies the text to display in the selection link. tmpl.Field_Info[N] .Lookup.LookupGrid.LinkLabel as C
Select record link label style	V7	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .Lookup.LookupGrid.LinkLabelStyle as C
Field map	V7	A comma delimited list of the fields to retrieve from the lookup window. tmpl.Field_Info[N] .Lookup.LookupGrid.ReturnFields as C A comma delimited list of the fields to write in the grid. tmpl.Field_Info[N] .Lookup.FillinFields as C
Link type	V7	Specifies whether to display text or a graphic as the link to the lookup window. The options are: "Text" "Icon" tmpl.Field_Info[N] .Lookup.LinkType as C
Link label	V7	If text is selected for link type, defines the text to display. tmpl.Field_Info[N] .Lookup.LinkLabel as C
Link label style	V7	Specifies style attributes that override the settings inherited from the style sheet. tmpl.Field_Info[N] .Lookup.LinkLabelStyle as C
Icon name	V7	If icon is selected for link type, defines the text to display. tmpl.Field_Info[N] .Lookup.IconName as C

RadioButton Properties

RadioButton controls are appropriate when you want to select between a small number of choices. The most important property for a check box control is the definition of its choices.

Note : When you allow the user to select multiple values, the control returns an array. To convert an array to a character value, you need to use an expression like the following.

TargetVariable = crlf_to_comma(ControlName.dump()

Radio Button Properties
Category	Options and Description
Choices	V6	Click to define the true and false choices set by the check box. Refer to Defining Choices for Check Boxes, Radio Buttons, and Drop Down Lists for details. Note : Logical values are represented by the values "True" and "False".
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .RadioButton.InLineStyle as C
Orientation	V6	The orientation of the label. The choices are: "Horizontal" "Vertical" tmpl.Field_Info[N] .RadioButton.Orientationas C
Type	V6	Select the Type of radio buttons you will have. The options are: "Static" - Predefined "Dynamic" - Computed (for example, by looking up information in a table) tmpl.Field_Info[N] .RadioButton.Typeas C
Maximum choices	V6	If you specified "Dynamic" radio buttons, enter the maximum number of choices to show. tmpl.Field_Info[N] .RadioButton.maxchoices as N
Style control if error	V6	Specifies whether to apply a second style to the field if a validation error occurs (V6). with tmpl.field_info[N] .RadioButton.StyleFieldIfError as L
In – line style for errors	V6	Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6). tmpl.Field_Info[N] .RadioButton.ErrorInLineStyleas C

Summary Values

Use summary values to display various types of information about the whole table. For example, you could place a total of all invoices, a count of invoices, and an average invoice value at the bottom of your grid. These calculations summarize all values on all pages of the grid, not just the visible page.

Also see the Summary Value options on the Grid Properties page.

Summary Value Properties
Category	Options and Description
Average	V6	Displays the average value of the fields in all the records of the table. tmpl.summary.average.label as C tmpl.field_info[N] .Summary.average.has as L .Summary.average.displayformat as C
Count	V6	Displays the count of the fields in all the records of the table. tmpl.summary.count.label as C tmpl.field_info[N] .Summary.count.has as L .Summary.count.displayformat as C
First	V6	Displays the first value found in the field. tmpl.summary.first.label as C tmpl.field_info[N] .Summary.first.has as L .Summary.first.displayformat as C
Last	V6	Displays the last value found in the field. tmpl.summary.last.label as C tmpl.field_info[N] .Summary.last.has as L .Summary.last.displayformat as C
Maximum	V6	Displays the maximum value found in the field. tmpl.summary.max.label as C tmpl.field_info[N] .Summary.max.has as L .Summary.max.displayformat as C
Minimum	V6	Displays the minimum value found in the field. tmpl.summary.min.label as C tmpl.field_info[N] .Summary.min.has as L .Summary.min.displayformat as C
Standard Deviation	V6	Displays the standard deviation of the fields in all the records of the table. tmpl.summary.stddev.label as C tmpl.field_info[N] .Summary.stddev.has as L .Summary.stddev.displayformat as C
Total	V6	Displays the total value of the fields in all the records of the table. tmpl.summary.total.label as C tmpl.field_info[N] .Summary.total.has as L .Summary.total.displayformat as C
Variance	V6	Displays the variance of the fields in all the records of the table. tmpl.summary.var.label as C tmpl.field_info[N] .Summary.var.has as L .Summary.var.displayformat as C

A portion of a grid showing five types of summary values. [Picture]

Tab Control and Tab Pane Properties

Optionally, add a Tab control (V7) to your grid. A tab control allows you to selectively hide and display different groups of fields. Refer to Setting Grid Tab Properties.

TextArea Properties

The most important properties of a TextArea control are the Rows and Columns properties, which define its size.

Text Area Properties
Category	Options and Description
Rows	V6	Sets the height of the control by specifying the number of rows. tmpl.Field_Info[N] .TextArea.Rows as N
Columns	V6	Set the width of the control by specifying the number of columns. tmpl.Field_Info[N] .TextArea.Cols as N
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .TextArea.InLineStyle as C

TextBox Properties

The most important properties of a TextBox control are the Size and MaxLength properties. The MaxLength should match the field definition in your table. The size can be larger or smaller than the MaxLength value, depending on the needs of your design.

Text Box Properties
Category	Options and Description
Size	V6	Sets the width of the field in characters. Note : No matter what you specify for height and width of a control, if the content is larger, then your browser will expand the table cell for you. There is no way to avoid this from the design of your grid or HTML. You can trim your data if it is crucial that your cells never expand. And even then, you have no control over the fonts being used by your user's browser so they could have things set to be really large and still be larger than the table cell. tmpl.Field_Info[N] .Textbox.Size as N
MaxLength	V6	Sets the maximum length of the user's input in characters. tmpl.Field_Info[N] .Textbox.MaxLength as N
Date Picker	V6	Specifies whether the control should have a pop-up calendar. tmpl.Field_Info[N] .DatePicker.Display as L
In – line style	V6	Specifies style attributes that override the settings inherited from the style sheet. Click to define the In-line style. Refer to the Style Editor for details. tmpl.Field_Info[N] .Textbox.InLineStyle as C
Is a password field	V7	If this is a password field, the characters will be replaced with bullets (V7). tmpl.Field_Info[N] .Textbox.IsPassword as L
Style control if error	V6	Specifies whether to apply a second style to the field if a validation error occurs (V6 only). tmpl.Field_Info[N] .Textbox.StyleFieldIfError as L
Control In – line error style	V6	Specifies style attributes that are used when a validation error occurs. Click to define the In-line style. Refer to the Style Editor for details (V6 only). tmpl.Field_Info[N] .Textbox.ErrorInlineStyle as C

See Next

Setting Grid Properties

Supported By

Alpha Five Version 6 and Above

Limitations

Web publishing applications only.