Every control cannot be morphed into every other type of control. Text box, for instance, can be converted into a label, list box or combo box. After morphing, a text box to list box, for instance, it is important to modify the control properties such as row source, bound column, column count and column width so that the changed control behaves in a desired manner. (x) Conditional formatting of text boxes : The conditional formatting is displayed in a text control when the value of text control meets a specified criteria or a set of specified criterion.
For example, the colour of Amount entered should turn Red when it exceeds a certain limit say Rs. , . In order to create conditional format, right click at text box to be conditionally formatted when in design mode, followed by conditional formatting item of right click window. Access responds by providing conditional formatting window which appears as follows : Conditional formatting window, as shown above, is divided into two parts: the default setting and condition- .
Since the formatting is to occur on the basis of a field value, the criteria list control can be used to select greater than and Rs. , is entered in the right most box of condtion- . There are five icons: bold, Italics, underline, Back colour and Fore colour for formatting the data value. As and when the condition is satisfied, the formatting based on the selected icons applies to the data value.
If there are multiple conditions for formatting, Add button can be clicked to call for additional formatting conditions. At the most three conditions can be set up for conditional formatting. Click OK to apply the conditions and click Delete to remove the conditional format. (xi) Re-arranging the Tab Order : The tab order of the Form (defined as a sequence of controls to move through when pressing a tab) is assigned while creating a Form.
The tab order goes out of sequence when the controls in the Form are re-arranged. An inconsistent tab order leads to an erroneous data entry. To change the tab order, choose