Understanding controls

Controls and properties form the basis of forms and reports. It is critical to understand the fundamental concepts of controls and properties before you begin to apply them to custom forms and reports.

The term control has many definitions in Access. Generally, a control is any object on a form or report, such as a label or text box. These are the same controls that you use in any Windows application, such as Access, Excel, or Web-based HTML forms, or those that are used in any language, such as .Net, Visual Basic, C++, or even C#. Although each language or product has different file formats and different properties, a text box in Access is the same as a text box in any other Windows product.

You enter data into controls and display data using controls. A control can be bound to a field in a table (when the value is entered in the control it is also saved in some underlying table field), or it can be unbound and displayed in the form but not saved when the form is closed. A control can also be an object, such as a line or rectangle. Calculated fields are also controls, as are pictures, graphs, option buttons, checkboxes, and objects.

Some controls that aren’t part of Access are developed separately—these are ActiveX controls. ActiveX controls extend the base feature set of Access 2007 and are available from a variety of vendors.

Many ActiveX controls are shipped with Access 2007. Whether you’re working with forms or reports, essentially the same process is followed to create and use controls. In this chapter, we explain controls from the perspective of a form.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
  • Fallene Cotz SPF 58 Water Resistant UVB/UVA Sunscreen for Sensitive Skin, 2.5-Ounce Tube User Reviews Send this to a friend Fallene Cotz SPF 58 Water Resistant UVB/UVA Sunscreen for Sensitive Skin, 2.5-Ounce Tube...
  • SEO Article Writing Services SEO Article Writing Services. Our SEO Article Writing Services are for those clients that want a professionally ghost written article...
  • Best Reasons to Use Unsecured Loans Prosper is a p2p lending marketplace for unsecured loans. Borrowers can borrow money up to $25,000 via an unsecured 3...
  • IPad Keyboard Dock Works with iOS4 [/caption] IOS4 will let you use a Bluetooth keyboard to type on your iPhone or iPod Touch and control various...
  • Small Business Coaching #af-form-1221758521 .af-body .af-textWrap{width:98%;display:block;float:none;} #af-form-1221758521 .af-body .privacyPolicy{color:#333333;font-size:12px;font-family:Verdana, sans-serif;} #af-form-1221758521 .af-body a{color:#8A0303;text-decoration:underline;font-style:normal;font-weight:normal;} #af-form-1221758521 .af-body input.text, #af-form-1221758521 .af-body textarea{background-color:#FFFFFF;border-color:#919191;border-width:1px;border-style:solid;color:#000000;text-decoration:none;font-style:normal;font-weight:normal;font-size:12px;font-family:Verdana, sans-serif;} #af-form-1221758521 .af-body input.text:focus,...
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>