working on form with control wizard on visual basic

Add This To Del.icio.us Share on Facebook StumbleUpon This Add to Technorati Digg This

Control wizard

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

For Further Reading,

Software Developing