--- title: "Set a Column's Format" slug: "set-a-columns-format" updated: 2024-03-26T19:21:23Z published: 2024-03-26T19:21:23Z canonical: "skthelp.syniti.com/set-a-columns-format" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Set a Column's Format Some control types allow a user to set the column’s format. | Control | Formats | | --- | --- | | Text Box | - Email - Password - Text | | Text Area | SQL | | Numeric | - Currency - Numeric - Numeric Positive - Percent - Zero Padded Integer | | DateTime | - Date - Date and Time - Formatted Date - Formatted Time - Time - Time (24 hour) | | Check Box | - SAP BDC > [!NOTE] > Note > > A check box using this format allows the values ~X" for checked and "!" for unchecked. The "!" is a special character used in an SAP BDC that tells the program there is no data in the field (i.e., the field should be ignored). This is useful when doing an update to existing data in SAP and the data must not change unless it has been modified. - SAP Checkbox - Deprecated > [!NOTE] > Note > > A check box using this format allows the values “X" for checked and for unchecked. - Y or N > [!NOTE] > Note > > A check box using this format allows the values “Y" for checked and “N" for unchecked. > [!NOTE] > Note > > If one of these formats is chosen for the check box, the data type of the table column in SQL must be set to a character of length 1. The user receives a hard error while entering data on the page if one of these check box formats is selected and the data type of the field is bit or another non-character format. > [!NOTE] > Note > > If the data type of the table column in SQL is set to bit, the Syniti Construct assumes the field is a check box and appropriately populates the data with a 1 or 0. | To apply formatting to a column, select an option from the Format list box on the *Page Columns* page's *Vertical* View. For a check box, select an option from the Checkbox Format ID list box. Numeric fields allow for additional formatting options. To apply additional formats to a numeric column: 1. [Access the Page Columns](/v1/docs/access-the-column-properties-page) *Vertical* View for a Numeric column. 2. Click **Edit**. [*View the field descriptions for the Page Columns page*](/v1/docs/page-columns-h) 3. Select an option from the **Format** list box. > [!NOTE] > Note > > Depending on the Format selected and the purpose of the field, set these additional options. 4. Enter a value in the **Numeric Scale** text box. > [!NOTE] > Note > > The Numeric Scale field determines the number of decimal places to display after the decimal separator. 5. Click **Display Thousands Separator** check box. > [!NOTE] > Note > > The Display Thousands Separator will force a number to use the current user's locale to display a number such as 4213.22 as 4,213.22 given that English - United States is selected in the Currency Locale ID list box. 6. Click **Total** check box. > [!NOTE] > Note > > A totals column recalculates when records are added, deleted, or modified. 7. Click **Save**.