Using Properties to Control a Form in Microsoft Access Database

Many customers of the Microsoft Access database find developing a form smooth enough. However, few know that each state has asset settings that you can exchange to govern the look and behavior. This academic will show you how to use the belongings sheet to manipulate a form’s residences. It will explain some unsurprising property settings in an MS Access form. Firstly, houses are fixed rules that govern pretty much about a shape, from the way it looks to the functions it performs. All Access database items, paperwork, tables, and reports have their homes. Also, every shape managed, including a label, a text field, and a button in Access, has its own set of residences. These properties are reachable through the belongings sheet. To carry up a form’s property sheet, 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 in a body. For example, you can pick out to have scroll bars, report selectors, or navigation buttons on the form. If you change the Navigation button’s belongings to No, the navigation buttons may be eliminated from the state. Now, the property sheet consists of many properties, and it might be very tough to allow you not to forget all of them. You can analyze greater approximately belongings objects by truly choosing the assets and pressing F1. On a regular help page, you need 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, and 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 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 effort for each of these residences to carry out by clicking the builder button with the three 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, some of which can be very useful. This consists of the Pop Up and Modal homes. If you convert the Pop Up property to Yes, the shape could perform like a pop-up window. With the Modal property, if you change it to Yes and run the form, it will have a 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.