Modifying Form Design : The Forms created with wizard have limited visual appeal. However, Forms have a design view, just as table do, and Access includes many tools for modifying a Form’s design. Some of the common modifications to the Form are listed below : Changing Properties of controls Re-sizing and moving controls Aligning and spacing controls Converting (or Morphing) controls Conditional formatting of controls Re-arranging Tab Order Adding New controls Deleting existing controls Each of these modifications has been briefly discussed after describing the procedure for creating a Form by Design view. (b) Create Form by Design view : Under this method, a data entry Form is created either as a data bound object or as an unbound object.
A double click at “Create Form in Design View” provides a New Form dialog but the Form created in this manner is not bound to any back end database. However, a click at New to open New Form dialog results in creating the Form, which is bound to database. The use of drop down list in the new Form dialog box to select a table or query serves as the foundation of the Form being created. Fields can be easily added to a Form by using the Field List window, which contains all the fields that are part of the Form’s record source.
The record source for the Form is the table or query that underlies the Form. Make sure that the Field List window is visible. If it is not, click at the Field List button on the tool bar. Pick up from the field list every field, which is to be displayed in the Form for entering the data.
It is important to ensure that every essential field must appear in the Form, if the Form is being designed to enter records rather than displaying just part of record contents. Select and drag the field from the field list to a place on the Form where it is desired to appear. The location selected becomes the upper left corner of the text box, and the attached label