Data Controllers / Data Fields

  Data Format String

Table of Contents
Data Controllers / Data FieldsPrint||
Data Format String

The Data Format String is used to format the value of a field before it is presented to the end user. It can be specified on the field itself, and will be applied to all instances of the field bound to the views (data fields). If it is specified on the data field level, then only that data field will use the data format string.

The Unit Price data fields in the Products controller are assigned the currency data format string of “c” by default.

On the Products page, the Unit Price field uses a standard currency data format string.

Let’s  assign the data field on the grid view a different format string.

Start the Project Designer. In the Project Explorer, double-click on Categories / Products / container1 / view1 / grid1 / UnitPrice data field node.

Unit Price data field in grid1 view on the Products page.

Change the Data Format String property:

Property New Value
Data Format String c4

Press OK to save the data field. On the toolbar, press Browse, and wait for the web application to load in your default browser.

Navigate to the Products page. The Unit Price data field on the grid view will be formatted with four numbers after the decimal place.

Unit Price data field in grid view shows 4 numbers after the decimal place.

Select a record. The Unit Price data field on the edit form will be formatted with the standard two numbers after the decimal place.

The Unit Price data field in the edit form uses the standard currency data format string.