It is help you to create a control, such as a list box or command button with the data or action, in a form, additional wizard are available for a combo box, option group.
Use picture tool
èThis control is use to static image in the form. It is not OLE Object that is embedded or linked. So if an image inserted, that same for the form and doesn’t change for the change in the data.
- Select Image tools
- Drag the required place
- Choose the image which is display on your form
- Define the image properties
- Height, width, border color, border style etc.
Using rectangle tool
It is used to set boundary of control to see our form an attractive
- Select rectangle tool and drag the required place and set the properties
Back style à transparency, Border colorà ‘Color’,
Border style, and border widthà size
Labels:
èYou use on a form, report or data access page to display descriptive text such as titles, captions, or brief instruction. Labels don’t’ display value from fields or expressions; they’re always unbound and they don’t change as you move from record to record.
Text box
èText box is use for data entry space or calculation box. So it can be
Bound: a text box is linked with a field of the table or query can be display the records of only that field.
Unbound: a text box that is not linked with any field of table or query and can contain any value is called unbound text box.
Calculated: a text box if contains a formula and calculates values from other text boxes (bound or unbound) and displays the calculated result.
Calculating in a text box
Display a form design view.
Insert a text box on the form
Now get the properties of the text
Select the "control source" and write formula as "= (formula)"
Inserting "go to next" button
Select the command button tool
Drag the required place in the form
You’ll get the screen choose "record navigation" category and select "go to next record" action and click on next
Select "picture" or "text" click on finish button
Inserting open form button
Select the command button tool
Drag the required place in the form
You’ll get the screen choose "form operation" category and select "open form" action and click on next
Select form which form you want to open
Select "picture" or "text" click on finish button
Inserting close form button
Select the command button tool
Drag the required place in the form
You’ll get the screen choose "form operation" category and select "close form" action and click on next
Select "picture" or "text" click on finish button
Inserting closing application button( close msaccess)
Select the command button tool
Drag the required place in the form
You’ll get the screen choose "application" category and select "Quit application" action and click on next
Select "picture" or "text" click on finish button
Some important properties of form
Caption à define the caption for the form to be displayed
Scroll barà enables or disables the scroll bar from the form
Navigation buttonsà to specify whether navigation buttons and a record number box are displayed on a form
Autos resize à to specify whether a form window opens automatically size to display complete records.
Min and Max buttonà: to specify whether the maximize and minimize button will be visible on the form
Close button à: to specify whether the close button on a form is enabled
Widthà to size object to specific dimensions
Pictureà background picture on a form .
Pop upàto display or not of access toolbar when form will maximize
Modelà to specify whether a form open as a model form
