Application Development

Set Default Field Value for a Column

A Column Property can populate a field with a pre-determined value.

A default value can be set for these controls:

• Check Box

  NOTE:The default value entered for a check box is dependent on the check box's field format. If the field format is ‘Y’ or ‘N,’ select one of these for the default value. If the check box does not have a format, the column in SQL must be of type ‘bit’ and a 1 or 0 must be entered as the default value. Refer to Set a Column’s Format for more information.

• HTML Area
• Text Box
• DateTime
• Combo Box
• Numeric
• List Box
• Text Area

To set a default value for a column:

1. Acess the Page Columns page's Vertical View for a Numeric column.

2. Click Edit.

   View the field descriptions for the Page Columns page

3. Click the General tab.
4. Enter the value in the Default field.
5. Click Save.