Microsoft Access 2010 Bible

Chapter 8: Working with Data on Access Forms

297

Use the Insert Object dialog box to add a new object to the OLE field, or add an object from an

existing file. The Create from File option button adds a picture or other OLE object from an exist-

ing file.

When displaying a picture in an OLE control, set the Size Mode property to control how the

image representing the OLE object is displayed. The settings for this property are

l Clip: Keeps the image at its original size and cuts off parts of the picture that don’t fit in

the control.

l Zoom: Fits the image in the control and keeps it in its original proportion, which may

result in extra white space.

l Stretch: Sizes image to fit exactly between the frame borders. The stretch setting may dis-

tort the picture.

Entering data in the Memo field

The Features field in the form shown in Figure 8.1 is a Memo data type. This type of field con-

tains up to 65,535 bytes of text. The first two sentences of data appear in the text box. When you

click in this text box, a vertical scroll bar appears, allowing you to view all the data in the control.

Better yet, you can resize the Memo control in the form’s Design view if you want to make it larger

to show more data. With the memo field’s text box selected, you can press Shift+F2 and display a

Zoom dialog box, as shown in Figure 8.5, to see more data. The text in the Zoom dialog box is

fully editable. You can add new text or change text already in the control.

FIGURE 8.5

The Zoom dialog box

Field being edited Zoom box