Ms Access 2010 tutorial: form property


Form Properties

III. Form Properties

When you create a form, it is necessary to know its properties. The Form Properties can help you to create a nice form. A form has a lot of properties, but in this section we introduce you only some necessary properties such as Caption, Border Style, Recorder Selectors, Navigation Buttons, Navigation Caption, Scroll Bars, Control Box, Movable, Split Form Size, Split Form Orientation, Split Form Splitter Bar, Split Form Datasheet, Split Form Printing, Pop Up, and Modal. Before you read the description of each properties, look the illustration below:

Access form shape 

The figure above call Form View.

III.1. Caption

Caption is used to set form's caption. For example, you want to set the words "Book Info" to frmBook's caption. To do so, do the following:

- Open frmBook in Design View or Layout View

- Press F4 if the Property Sheet does not display, and then type the words "Book Info" in front of Caption property as shown figure:

Access caption 

Note: In default, the form uses its name as its caption when you don't set it caption.

III.2. Border Style

This form's Border Style property is used to set the different styles of form's border as the following:

- None: This option is used to remove the border of form.

- Thin: When you select this option, your form's border look thinner and cannot resize.

- Sizable: This option use for setting form's border can be resizable.

- Modal: When you select this option, your form's border look thinner and cannot resize as you set form's border to Thin. Modal style displays only close button while Thin style displays control box including min, max, and close button.

Note: When you change each form's border styles to see its effects, you need to view the form.

III.3. Record Selectors

In default, when you create a form, Access sets the Record Selectors to the form. But you can take it out when you don't need it. To remove the Record Selectors on the form, do the following:

- Open your form in Design View or Layout View

- Press F4 if the Property Sheet does not display, and then set No to the Record Selectors as shown figure:

Access record selectos 

III.4. Navigation Buttons

When you create a form, Access set the Navigation Buttons to Yes to the form. You see it when you view the form. If you want to remove it, do the following:

- Open your form in Design View or Layout View

- Press F4 if the Property Sheet does not display, and then set No to the Navigation Buttons as shown figure:

Access navigation buttons 

III.5. Navigation Caption

The role of Navigation Caption property is to set caption to the Navigation. The Navigation Caption displays the word "Record" in front of the Navigation Buttons when the caption is not set.  To see it, look Form View figure above. For example, you want to set the words "Move Record" to the Navigation Caption property. To do so, do the following:

- Open your form in Design View or Layout View

- Press F4 if the Property Sheet does not display, and then type the words "Move Record" in front of the Navigation Caption as shown figure:

Access navigation buttons 

III.6. Scroll Bars

You use Scroll Bar property to display or not to display scroll bars vertically or horizontally or both. This property has the following value:

- Neither: If you do not need scroll bar to display on the form, select this option.

- Horizontal Only: This option displays only horizontal scroll bar.

- Vertical Only: If you want to show vertical scroll bar on the form, select this option

- Both: This option shows both vertical and horizontal scroll bar.

III.7. Control Box

This property allows you to set or remove control box on the form. Control Box has two values:

- Yes: Access displays control box.

- No: Access does not display control box.

III.8. Movable

If you want your form can be movable, set the Movable property to Yes. If not set the Movable property to No.

III.9. Split Form Size

This property is used to set size of the split form. You cannot set size of  the split form below or above the defined values. The minimum size of the split form is 1 inch while maximum size is 3 inches. For instance, you want your split form's size is 1.5 inches. To do so, do the following:

- Open your form in Design View or Layout View

- Press F4 if the Property Sheet does not display, and then type 1.5" to the Split Form Size as shown figure:

Access split form view 

The figure below shows default split form's size and split form splitter bar. The example above set 1.5 inches to the split form's size, so the size of split form is smaller than the figure. This figure calls Split Form View.

Access split form view 

III.10. Split Form Orientation

When you create a split form, Access display a form view on the upper section and the datasheet view on the lower section as the Split Form View figure above. However, you can change the direction of the datasheet to top, bottom, left or right.  If you want to change the datasheet's direction, do the following:

- Open your form in Design View

- Press F4 if the Property Sheet is not displayed, and then click drop-down arrow in front of  the Split Form Orientation as shown figure:

Access split form orientation 

- Click any directions that you like.

III.11. Split Form Splitter Bar

If you want to split form splitter bar to display on your form, set the Split Form Splitter Bar property to Yes. If not, set the Split Form Splitter Bar property to No. To see the split form splitter bar, look the Split Form View figure.  To set or remove the split form bar on  the form, you must open the form in Design View and find it in the Format tab of the Property Sheet.

III.12. Split Form Datasheet

This property have two options:

- Allow Edits: If you select this option, you can edit data in the datasheet.

- Read Only: You cannot add or edit data in the datasheet, but you can delete the data if you select this option.

To use the options above, you need to open form in Design View or Layout View.

III.13. Split Form Printing

When you print the split form, you can choose to print the form in form view or the datasheet view. If you want to print  the form in datasheet view, select Datasheet Only option. Alternately, select Form Only option if you intend to print the form in form view.

Access split form printing 

To use the options above, you need to open form in Design View or Layout View.

III.14. Pop Up

This property sets the form to load in or on Microsoft Access Window when you set it to Yes.  If you want to use this property, you need to open the form in Design View or Layout View.

III.15. Modal

Modal property is used with Pop up property. If you intend to open only one form, you must set Pop Up and Modal property to Yes. If you want to use this property, you need to open the form in Design View or Layout View.


Comments




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.