Change the type of link for a picture or other object on a form or report

When you link to an object that was created in another application, Microsoft Access creates an automatic link by default. You can change the type of link to manual, or vice versa.

Note   This type of link is different from a hyperlink that is used on a form or report to jump to another document, object, or page. For more information on hyperlinks, click .

1. Do one of the following:
   • If the object is unbound, click the object in form or report Design view.
     
     
   • If the object is bound, open the form in Form view (or open a datasheet), find the record that you want to change, and click the object.
2. On the Edit menu, click OLE/DDE Links.
   
   
3. In the Links box, click the link that you want to change. To select multiple links, hold down the CTRL key while you click each link.
   
   
4. Click Automatic or Manual.

Notes

• When you make any changes to a link for a bound object frame, you are changing the link only for the current record. To make a change in a different record, move to that record and repeat the process.
  
  
• This procedure only applies to pictures in unbound object frames and bound object frames. Background pictures and pictures in image controls are always updated automatically.