You can customize the data appearance on the List/View/Print/Export pages using formatting options on the View as settings dialog. You can define the field settings for all pages at once or separately for each page.
To control the field appearance on the page, click on the field and then on the View As/Edit as button in the properties.
To set different field formats for different pages enable the Use different settings for all pages checkbox.
Depending on the selected format, you will see different dialogs.
Copy settings option allows you to copy field settings from another field.
Field events option allows performing an action when the cursor enters, leaves or is over an edit field. Perform any sort of validation, make other fields hidden or required, etc. Field events are designed to work on Add, Edit, View and Register pages.
For example, the mouseover event occurs when the pointer is over the selected element.
The values are displayed as text.
Truncate large text fields
This option limits the number of characters that can be displayed in a single text field on a page. The "More ..." link appears if the number of characters is higher than the number you have entered into the Characters to display field.
Dates will be displayed in a short format ( 02/17/2003 ).
Dates will be displayed in a long format ( 17 February 2003 ).
Datetime values will be displayed as date and time ( 02/17/2003 14:22:03 ).
Datetime values will be displayed as time ( 14:22:03 ).
Numeric values like 14000 will be displayed as $14 000.00 (actual format depends on your system regional settings like currency symbol, decimal symbol, etc.).
Example: 0.38 will be displayed as 38%.
Choose this format if you store hyperlinks in this database field. Those hyperlinks will be made clickable automatically.
Choose this format if you store email addresses in this database field. It will be converted into mailto HTML code automatically.
Choose this format if you store files in this field. For more information, see "View as" settings: File.
Choose this format if you store images in this field. For more information, see "View as" settings: Image.
Formats number as a US phone number. Supports 7-digit or 10-digit numbers (123) 456-7890 or 123-4567.
Choose this format if you like to format this field as a number. You can set the default number of digits after the comma for all numeric fields.
Use this view type when you store formatted HTML code in the database field and wish to display this HTML code on the List page.
Use this view format to present field value as a check box. Works best with the following data types:
•MS Access: Yes/No field
•SQL Server: TINYINT or BIT field
Allows adding maps to the web pages. For more information, see "View as" settings: Map.
Allows formatting field values by adding C#/VB.NET code. For more information, see "View as" setting: Custom.
Choose this format if you store audio files in this field. For more information, see "View as" settings: Audio.
Choose this format if you store video files in this field. For more information, see "View as" settings: Video.
The QRCode control allows you to add QR Codes to your pages. For more information, see "View as" settings: QRCode.