Reference: Data Designer Properties

 

For the latest documentation on Visual Studio 2017, see Visual Studio 2017 Documentation.

You can modify the format and behavior of data by setting the value of properties in the Properties window. The following tables describe each property.

NameDescription
Default ScreenIf more than one Details screen is defined in the application, this property specifies which screen appears by default when a user opens a detail view of an item of data.
Plural NameThe name used to describe a collection of the current type. This name appears in Solution Explorer. This name also appears in IntelliSense when you refer to the collection by using custom code.
Is ComputedIndicates whether the value of the field is computed. For more information, see How to: Add a Computed Field.
Is SearchableIndicates whether the contents of this field are searchable.
NameThe name of the field, table, or entity.
Choice ListA list of name value pairs. Create a choice list to enable users to select a value from a drop-down list. For more information, see How to: Create a List of Values for a Field.
Include in Unique IndexEnsures that the value of this field combined with the value of other fields in the unique index are unique. For more information about unique indexes, see Unique Index Design Guidelines.
Default Email DomainApplies to the EmailAddress business type. Appends an email domain to the end of a valid email address alias.
Enable Created/Modified propertiesWhen selected, adds four fields to the entity to identify the user who created or most recently updated the record and the time when the record was created or most recently updated. The time is stored as a Date Time Offset data type. See How to: Implement Row Tracking. Note: The Enable Created/Modified properties property appears for tables in the intrinsic database only.
NameDescription
DescriptionThe text that appears as the default tooltip for this item in a screen. If you add text to the Description property of a control that displays this item, then that description is used as the tooltip instead.
Display NameEnter the name that is displayed on a screen for the field, table, or entity.
Summary PropertyWhen the entity or table appears in a group that uses the Summary control type, this property specifies which field of the entity or table appears in each row of the group. For more information about the Summary control type, see Reference: Screen Designer Properties.
Display by DefaultSpecifies whether the currently selected field appears in screens. If you clear the Display by Default check box, and you want this field to appear in a screen, you will have to drag this field from the screen members list to the screen content tree in the screen designer.
Currency SymbolApplies to the Money business type. The name of the locale for the currency. For example, if your currency is listed in United States Dollars, specify en-US.
Decimal DigitsApplies to the Money business type. The number of decimal digits to display. For example, specify 2 to display two digits after the decimal.
Is FormattedApplies to the Money business type. Specifies whether to display the currency symbol, digit grouping separator, and custom decimal digits. You can then decide which of these three items you want to display by modifying the Symbol Mode, Is Grouped, and Decimal Digits properties.
Is GroupedApplies to the Money business type. Displays a digit grouping separator. For example, if you select this option, a monetary value will display as 1,234.56 rather than 1234.56.
Symbol ModeApplies to the Money business type. Displays the currency symbol from this drop-down list. To display the currency symbol, select Currency Symbol or ISO Currency Symbol. To stop the display of the currency symbol, select No Currency Symbol.
Percent Decimal PlacesApplies to the Percent business type. The number of decimal digits to display. For example, specify 2 to display two digits after the decimal.
Phone Number FormatsApplies to the PhoneNumber business type. Specifies how you want to validate and display phone numbers. You specify the format for the phone number using the letters C for country code, A for area or city code, and N for local number, and any symbols that are currently used to display phone numbers, such as +, -, (, ), ., and spaces. For example, to display a North American phone number, you specify any of the following formats:

1. C-AAA-NNN-NNNN
2. AAA-NNN-NNNN
3. (AAA) NNN-NNNN
4. AAA.NNN.NNNN

When users type a phone number, the application first tries to validate the phone number against the first format in the list. If the digits match the format, then the phone number appears in that format. Otherwise, the application tries to validate the phone number against the remaining formats in the list until a match is made.
NameDescription
Format PatternSpecifies the display format for numeric and date data types. For example, you might want to display a Decimal value as a percentage (12.2%), or display a date that includes the day of the week (Monday, July 4, 2011). For more information, see How to: Format Numbers and Dates
NameDescription
Is RequiredIndicates whether the field must have a value. If a value is required, select this check box.
Maximum LengthSpecifies the maximum length of the field in characters.
Maximum ValueSpecifies the maximum value of the field.
Minimum ValueSpecifies the minimum value of the field.
PrecisionSpecifies the maximum number of digits for the value of the field. This includes digits both left of and right of the decimal point.
ScaleSpecifies the maximum number of digits to the right of the decimal point for the value of the field.
Require Email DomainApplies to the EmailAddress business type. Indicates whether the user must provide an email domain as part of an email address that they type into a field of type EmailAddress.

Reference: Screen Designer Properties
Reference: Query Designer Properties
Data: The Information Behind Your Application

Show: