Access 2010 includes a new Web Browser Control that allows you to display Web pages on a form. You can link the control to fields or controls in your database to dynamically determine which page is displayed. For example, you can use address information in a database to create custom maps on an Internet mapping site, or you can use product information in a database to search for items on a supplier’s Web site.
Add a Web Browser Control to a form
Adding a Web Browser Control to a form is similar to the process of adding other controls, such as text boxes or command buttons. The main difference is in how you create the control source for the control. Instead of an expression or object name, the control source for a Web Browser Control is a Web page URL. Use the following procedure to get started.
- In the Navigation Pane, right click the form to which you want to add a Web Browser Control, and then click Layout View.
- On the Design tab, in the Controls group, click Web Browser Control.
- Position the pointer where you want the control, and then click to place it.
Access opens the Insert Hyperlink dialog box.
You can type the base URL, paths, and parameters directly into the boxes, but the easiest way to enter the URL is to browse to the site, copy the address, and then let Access parse the address into its component parts. Use the following steps to accomplish this task:
- Click the Browse the Web button to the right of the Address box.
- In your Web browser, navigate to the page you want displayed in the control. If the page you want to display is a “results” page of a search engine, then get that page to display by entering a typical search term and searching for it.
- When the page you want is displayed in your browser, copy the URL from the address bar, and then close the browser.
- In the Insert Hyperlink dialog box, paste the URL into the Address box, and then press the TAB key.
Access clears the Address box, and separates the URL into the appropriate boxes: Base URL, Paths, and Parameters. The complete URL is displayed in a box below the Paths and Parameters lists.
- If you want to display the same Web page regardless of what data is displayed on the form, click OK in the Insert Hyperlink box and continue with the next section. Otherwise, continue with the next step.
- To set the Web Browser Control so that its URL changes based on the data that is displayed on your form, you must replace the appropriate URL components with expressions that refer to the appropriate controls on the form. For each component that you want to replace:
- Click the path or parameter that you want to replace, and then click the Build button .
- In the Expression Builder dialog box, if the element lists are not displayed, click More >> to display them.
- In the element lists, find the control that contains the data you want to be substituted for that path or parameter, and then double-click it to add it to the expression box.
- If there are any other calculations that must be done with the value, add the necessary operators and expression elements, and then click OK to close the Expression Builder.
- Click OK in the Insert Hyperlink dialog box.
If you are having trouble constructing the correct URL for a particular site, you might need to consult the Help or support pages of that site for further information about how to build a URL.
For more information about creating an expression, see the articles Create an expression or Use the Expression Builder.
Top of Page
Change the position and size of the Web Browser Control
When you first place the Web Browser Control on a form, it might occupy a fairly small cell in a layout. In most cases, you will need to adjust the layout to show as much of the Web page as possible. A good way to get started is to merge the cell that contains the control with adjacent empty cells:
- Select the cell that contains the Web Browser Control.
- Hold down the CTRL key and select any empty adjacent cells that you want the control to occupy.
- On the Arrange tab, in the Merge / Split group, click Merge.
- Resize the resulting cell by selecting it and dragging its edges until it is the size you want.
Top of Page
Modify the control source of a Web Browser Control
After adding a Web Browser Control to a form, you might need to make further modifications to its control source (URL). Use the following procedure to open the Insert Hyperlink dialog box so that you can make changes.
- In the Navigation Pane, right click the form to that contains the Web Browser Control, and then click Layout View.
- Right-click the Web Browser Control, and then click Build Hyperlink.
- In the Insert Hyperlink dialog box, make the necessary changes to the URL components, and then click OK.
Top of Page