Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] - نسخه متنی

Alison Balter

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید



Control Morphing


When you first build a form, you might not always choose the best type of control to display each field on the form, or you might make what you think is the best choice for the control, only to find out later that it wasn't exactly what your user had in mind. In Access, it's easy to

morph , or convert, the type of control into another type. For example, you can morph a list box into a combo box, a text box into a combo box, or a combo box to a text box.

Morphing a Text Box to a Combo Box


One of the most common types of conversions is from a text box to a combo box. To morph a text box to a combo box, right-click on the text box. Choose Change To, and then select Combo Box. The types of controls available depend on the type of control you're morphing. For example, a text box can be converted to a label, list box, or combo box (see Figure 5.29).

Figure 5.29. Morphing a text box.


After morphing a text box to a combo box, you modify the appropriate Control properties. The Row Source, Bound Column, Column Count, and Column Widths properties need to be filled in. For the row source, you must select the appropriate table or query. If you select a table and then click the ellipsis, you are prompted to create a query based on the table. After selecting Yes, you can build a query containing only the fields you want to include in the combo box. You're then ready to select the bound column, which is used to store data in the underlying table. For example, the user might select the name of a project that a payment is being applied to, but the ProjectID will be stored in the Payments table. Set the column count to the number of columns selected in the underlying query; the column widths can be set so that the key column is hidden.

Morphing a Combo Box to a List Box


Morphing a combo box to a list box is a much simpler process than morphing a text box to a combo box or a list box because combo boxes and list boxes share so many properties. To morph a combo box to a list box, simply right-click on the combo box and choose Change To, List Box.


/ 544