A lot of people, familiar with Microsoft Access, consider creating form to be very easy. But not everybody knows that there are special property settings, which can change the form?s look and behavior. In this Access tutorial you will find out how to apply property sheet for managing form?s properties.
Form properties are certain rules that control almost everything about a form like its looks as well as its functions. Just as form, all other Access database objects have their own properties. And every form item like a text box, label or a button also has its own properties. You can access these properties through the property sheet. When you want to open a property sheet of a form, click the button at the form?s top left corner. You will see that there are different categories of properties in the property sheet.
The Format category is responsible for the look of the form. Using these properties, you will be able to control the form?s appearance and what items you want to see in your form. You can choose things like scroll bars or navigation buttons to be in the form. If you want to remove the navigation buttons from your form, then you should change it to NO.
There are many properties in the property sheet, so it is difficult to remember all of them. But if you select the property item and press F1, you can learn a lot about a property you are interested in. Then, on a help page, you can get a brief explanation of every property and an example how to use it.
With the data properties, you can regulate things like data source, whether you should allow the users to edit or delete the data or not and what exactly users can do with the data in the form. So, in case you want the users just to enter data into the form and not view it, then you change No to yes in the Data Entry property.
There are also event properties that are used for defining a certain occurring event, like form opening or changing the data, etc. You can make all these properties carry out a particular action just by clicking on the builder button.
The other properties group contains various items and you can make use of some of them. Among miscellaneous properties you can see a Pop up property. And if you change it to Yes, your form will be appearing like a pop up window. And in the All property category tab, you can simply put all of them together. You will see a long list of different properties available for you to use and make your form more functional and better looking.
Anything about microsoft access database: great training info, all sorts of business products (that can be tailored for the specifics of your business), special microsoft access database blog with hints, tips and tricks about MA databases.
All this and more from a trustworthy UK based company which majors at microsoft access database and is helping clients round the globe.