.OLE (Object Linking and Embedding) objects are objects not part of an Access database. These commonly include pictures but an OLE field can also contain links to objects such as Word documents, Excel spreadsheets,and audio files such as .mp3, .wav, or .wmv files. You can also include video files such as .mpg or .avi files.

In Datasheet View, you can’t view a picture or any OLE object without accessing the OLE server (such as Word, Excel, or the Microsoft Media Player). In Form View, however, you can size the OLE control area to
be large enough to display a picture, business graph, or any visual OLE object. You can also size text-box controls on forms so that you can see the data within the field—you don’t have to zoom in on the value, as you do with a datasheet field.

Any object supported by an OLE server can be stored in an Access OLE field. OLE objects are entered into a form so that you can see, hear, or use the value. As with a datasheet, you have two ways to enter OLE fields into a form:

• Paste them in from the commands in the Home tab’s Clipboard group.
• Right-click on the OLE field and click Insert Object from the pop-up menu to display the Insert Object dialog box, shown in Figure 35-25.

FIGURE 35-25
The Insert Object dialog box.

Use the Insert Object dialog box to add a new object to the OLE field, or add an object from an existing file. Choose the Create from File option button to add a picture or other OLE object from a file that already exists.

When displaying a picture in an OLE control, set the Size Mode property to control how the picture is displayed. The settings for this property are:

• Clip: Keeps the picture at its original size and truncates any portion of the picture that doesn’t fit in the control.
• Zoom: Fits the picture in the control and keeps it in its original proportion, which may result in extra white space.
• Stretch: Sizes picture to fit exactly between the frame borders; this setting may distort the picture.

• Collecting Antique Photography It may be difficult for you to understand why anyone would want to give away or to sell their family...
• 20th Anniversary of the Hubble Space Telescope [/caption] The Hubble telescope, launched on 24 April 1990, has had a chequered history, requiring major repairs early in its...
• Can Objects Open Doors for the Demonic? I've had other people ask me questions about other topics. Someone asked me about what they should do about a...
• PHP Class for better cache - fileCache Last days I'm working making many changes in Open Classifieds and one of them is this new class to handle...
• Weakon 305: Mutual Funds, Intermediate Prerequisites: Weakon 205 & Weakon 235 I've already established a mutual fund is essentially a company you buy shares in...