control. However, the input mask property of control in the Form is used to further restrict what data is entered into the field. Default Value : This property determines the value assigned to the field while adding a new data record. It is inherited from the underlying field of record source to which the control is bound.
The default value, when set for control, has an overriding effect over the default value set at the underlying field level. Validation (Rule and Text) : The function performed by Validation Rule and Validation Text for controls is the same as it applies to Fields of database tables, except that the validation is performed at Form level in case of control and database level in case of fields. In case of bound controls, the user cannot enter data into the control, if the validation rules for control and the underlying field are in conflict. Enabled and Locked : This property is meant to determine whether focus is allowed on the control or not.
If it is set to No , the control appears dimmed and mouse action cannot be performed on such control. This property is useful for calculated controls meant only for display of data. Locked property determines whether the data in the control can be modified or not. This property, when set to Yes, deprives a user the facility to edit data, though the focus becomes available.
The two properties interact with one another resulting in following behaviour of control : Locked Enabled Effect : The control can Yes Yes get focus ; its data can be copied but not modified No Yes get focus and its data can be modified Yes No not get focus No No not get focus; its data is displayed dimmed (c) Other Properties Name : This property allows the designer to provide a customised name to a control. The names assigned by the designer should be purpose oriented so that the design structure of the Form becomes self- documenting. Status Bar Text : This control specifies the text message that is displayed in the