Using Properties to Control a Form in Microsoft Access Database

Many customers of the 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. This academic will show you the way to use the belongings sheet to manipulate a form’s residences. It will explain some of the not unusual property settings in an MS Access form. Firstly, houses are fixed of rules that govern pretty much 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.

maxresdefault.jpg (1280×720)

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 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 many 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. On a regular help page, you need to get a quick clarification, syntax on how to use the assets as part of an expression, some comments, and a few instances 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, if you don’t need customers to view records with this shape and only allow them to enter facts, 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, including 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 using 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 the 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 will 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.



Writer. Extreme twitter advocate. Hipster-friendly food expert. Internet aficionado. Earned praised for my work analyzing Yugos for the government. Spent 2002-2008 short selling glucose with no outside help. Spent several months developing strategies for xylophones in Ocean City, NJ. What gets me going now is supervising the production of cod in Cuba. Spoke at an international conference about supervising the production of inflatable dolls in Hanford, CA. Spent two years short selling cabbage in Tampa, FL.