Editing OLE Objects in Forms and Tables
You can edit linked or embedded data in a table or form while designing the table or form. In addition, you can edit the data in a form while running the form. The following procedures describe the ways you can edit data.
To edit data in a General field in a table
- Open and browse the appropriate table.
- Go to the record containing the General field you want to edit.
- Double-click the General field to display the editing window.
- In the editing window, double-click to edit the data.
To edit embedded or linked objects on a form while designing the form
- Select the object representing the data.
- With the mouse pointer over the object, click the right mouse button.
- From the shortcut menu, choose the object type, and then choose Edit or Open.
To edit objects or data from General fields on a form while running the form
From the Edit menu, select the object.
For example, if the object is a Microsoft Excel worksheet, select Spreadsheet Object from the Edit menu.
Tip You can also right-click on the object if its AutoVerbMenu property is set to True. Choose the object type, and then choose Edit or Open.
To edit the object visually, choose Edit from the submenu.
-or-
To edit the object in a separate window, choose Open from the submenu.
Caution If you change the data in an object while running a form, Visual FoxPro saves the changes only if the data is linked or is associated with an OLE Bound control. Changes associated with an OLE Container control are not saved.
If you edit in the Visual FoxPro window, menus from the application you're using replace or merge with Visual FoxPro menus. For example, if you're using Microsoft Excel, the Excel Edit menu replaces the Visual FoxPro Edit menu. However, the Visual FoxPro File, Program, and Window menus are not replaced.
See Also
Displaying Embedded or Linked Data from Tables | Replacing Linked or Embedded Data with Static Data | Dynamic Information Sharing | Importing and Exporting Data | Adding OLE