Use the Set Initial Value To properties to initialize field values.
|
Go to: |
Tools, Properties..., Initial Value tab |
The Set Initial Value To properties designate how to initialize the field.
|
|
Use the Set Initial Value To properties to initialize field values. |
|
Options |
Description |
|
Current date |
The field is initialized to the current date only of the system running your application. The time is unspecified. |
|
Current date and time |
The field is initialized to the current date and time of the system running your application. |
|
Logged in user ID |
The field is initialized to the ID of the currently logged in user. This option is available only when application security is enabled. |
|
Constant |
The field is initialized to the constant value you specify. The constant you specify should appropriately match the underlying database field type and field validation type, if any. |
|
URL parameter |
The field is initialized to the value passed into the page via the specified URL parameter. Enter the URL parameter name whose value will be used. See Using URL Parameters for details on passing data via URL parameters. |
|
Custom function |
The field is initialized to the value returned by a custom function in your code. See The Query Wizard for details on calling custom functions. |
Setting the Initial Value overrides any value already stored in the database for the field. For example, an Edit Record page will replace an existing field value with the initial value.
If you initialize a field for which the Display Foreign Key As option is set, the initialization value “supersedes” the Display Foreign Key As setting and the database will not be queried to display the string value corresponding to the initialization value unless the Control Type is a list box, dropdown list, or radio button list. These control types require the database to be queried to determine all of the foreign key values in order to build the list; this is not true for Control Types that display only a single value – the initialization value.
FieldValue Control Type Properties
FieldValue Display Format Properties
Label and Literal Control Options
File Upload and File Download Control Options
FieldValue Initial Value Properties
FieldValue Pass-Through Attributes