Using Properties to Control a Form in Microsoft Access Database

Many customers of Microsoft Access database find developing a form smooth enough. However, now not many are aware that each form has assets settings that you can exchange to govern the look and behavior of a form. This academic will show you the way to use the belongings sheet to manipulate a form’s residences. It will even give an explanation for come of the not unusual property settings in an MS Access form.

Firstly, from houses are a fixed of rules that govern pretty a great deal the entirety about a shape, from the way it looks to the functions it performs. Note that all Access database items; paperwork, tables, reports have their personal homes. Also, every shape manages including a label, a text field, a button in Access has its very own set of residences.

These properties are reachable through the belongings sheet. To carry up the property sheet of a form, double click on the button on the pinnacle left corner of the shape. The assets sheet groups the homes into distinctive categories.

Format class

Format properties manage the advent of a shape. You can use these residences to control how it looks and what type of things you want on a shape. For example, you can pick out to have things like scroll bars, report selectors or navigation buttons on the form. If you change the Navigation buttons belongings to No, the navigation buttons may be eliminated from the form.

Now, the property sheet consists of a lot of properties and it might be very tough that allows you to don’t forget all of them. You can analyze greater approximately belongings object with the aid of truly choosing the assets and pressing F1.

maxresdefault.jpg (1280×720)

On a regular help page, you need to get a quick clarification, syntax on a way to use the assets as part of an expression, some comments and a few instance of the property getting used.

Data houses

With these properties, you can manipulate such things as facts supply that the form binds to, whether or not you allow users to edit, upload or delete current facts, what type of things users can do with the statistics on the form. For instance, in case you don’t need customers to view records with this shape and also you only allow them to enter facts, then you definitely change the Data Entry property from No to Yes.

Event homes

These homes are used to outline a fixed of actions upon an event taking place which include the opening of the form, information update by using a person etc… You can define an action for each of these residences to carry out by means of clicking the builder button with the 3 little dots. This will bring up the Choose Builder dialog permitting you to outline a motion using the Expression Builder, Macro Builder or Code Builder if you’re familiar with Visual Basic for Application.

Other properties

This includes all miscellaneous items and some of them can be very useful. This consists of the Pop Up and Modal homes. If you convert Pop Up property to Yes, this could make the shape performing like a pop-up window. With the Modal property, if you change it to Yes and run the form, it’s going to have the one of a kind focus. If you want to move the focus to any other item, you must close the shape before you may do so.