The Edit edit style
By default, columns use the Edit edit style, which displays
data in an edit control. You can customize the appearance and behavior
of the edit control by modifying a column’s Edit edit style.
To do so, select Edit in the Style Type drop–down
listand specify the properties for that style:
-
To restrict the number of characters users can
enter, enter a value in the Limit box. -
To convert the case of characters upon display,
enter an appropriate value in the Case box. -
To have entered values display as asterisks for
sensitive data, check the Password box. -
To allow users to tab to the column but not
change the value, check the Display Only box. -
To define a code table to determine which values
are displayed to users and which values are stored in the database,
check the Use Code Table box and enter display and data values for
the code table.
To use the Edit edit style:
-
Select Edit from the Style Type list, if
it is not already selected. -
Select the properties you want.
Date columns and regional settings
Using the Edit edit style, or no edit style, with a date column
can cause serious data entry and validation problems if a user’s
computer is set up to use a nonstandard date style, such as yyyy/dd/mm.
For example, if you enter 2001/03/05 in the Retrieval
Arguments dialog box for a date column when the mask is yyyy/dd/mm,
the date is interpreted as March 5 instead of May 3. To ensure that
the order of the day and month is interpreted correctly, use an EditMask
edit style.