Using the Values property page

Unlike the other property pages, the Values property page does not use the tree view model. Instead, it provides a set of controls for specifying the properties of the ValueItems collection associated with each Column object, and a translation table for populating the collection with ValueItem members. The Values property page contains the following controls:

Column

Use this combo box to select the column to be modified. Like the properties in the Columns property page, the ValueItems collection of a Column object is global, which means that it cannot vary from one split to another.

Translate

This check box determines whether data will be translated before it is displayed in the column. It corresponds to the Translate property of the ValueItems collection, which defaults to False. Note that the DisplayValue column of the translation table is only visible when this box is checked.

AnnotatePicture

This check box determines whether both text and graphics can be displayed in the same cell. It corresponds to the AnnotatePicture property of the ValueItems collection, which defaults to False.

Presentation

This combo box controls whether value items are displayed as a set of radio buttons, a drop-down combo box, check boxes, or text. It corresponds to the Presentation property of the ValueItems collection, which defaults to 0 - Normal (normal text display).

Value (first column of translation table)

Entries in this column match the underlying data value stored in the database. For translation purposes, this value must match the string representation of the underlying data, which is used internally by the list. Depending on how the data source converts numbers to strings, there may be an extra space, for a possible minus sign, at the beginning of the string representation. Therefore, you may need to pad entries in this column with a single space. This column corresponds to the Value property of the ValueItem object.

DisplayValue (second column of translation table)

Entries in this column contain the translated display value, if desired. For example, to display 1 as Yes, enter 1 in the Value column, and Yes in the DisplayValue column. This column corresponds to the DisplayValue property of the ValueItem object. Note that the DisplayValue column is only visible when the Translate box is checked.

Append

This command button adds a new blank row to the end of the translation table for entering additional data values. The new row becomes the current row.

Insert

This command button inserts a new row above the current row of the translation table for entering additional data values. The new row becomes the current row.

Remove

This command button deletes the current row from the translation table.

Picture

Use this button to open a bitmap file selection dialog box. Locate the bitmap you want to display, and then press the OK button in the dialog box to load the bitmap into the DisplayValue column.

Record Selectors (translation table)

Select a row in the translation table to specify a default value to display whenever a data value not present in the ValueItems collection is encountered. The index of the selected row corresponds to the DefaultItem property of the ValueItems collection.