ACC2000: Using AutoFormat Changes Appearance of Hyperlinks

• Microsoft Access 2000

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you use the AutoFormat feature on a form that contains a hyperlink, the default color for the hyperlink text is changed.

CAUSE

By default, the hyperlink color is what is specified in the Followed Hyperlink Color or Hyperlink Color box on the Hyperlinks/HTML tab of the Options dialog box. However, because the hyperlink control is considered a label, it uses the default color specified for labels in the format selected with the AutoFormat feature.

RESOLUTION

There are two methods that you can use to set the color for the hyperlink text:

• You can set the color for the hyperlink text by using the ForeColor property for the control.
  
  -or-



• You can specify the color of the hyperlink text by using code.

Setting the Color for the Hyperlink by Using the ForeColor Property

1. Right-click the hyperlink control, and then click Properties on the shortcut menu.



2. In the Properties dialog box, click the Format tab. Scroll down to ForeColor, and select the color that you want.

Setting the Color for the Hyperlink by Using Visual Basic Code

1. Open the form in Design view.



2. On the Edit menu, click Select Form.



3. On the View menu, click Properties.



4. In the Form dialog box, click the Event tab, and then click in the OnCurrent box.



5. Click the Build button to the right of the OnCurrent box. In the Choose Builder dialog box, click Code Builder, and then click OK.



6. To set the color for the text, type or paste the following sample line of code into the Sub procedure:




Me!HyperLinkControlName.ForeColor = 255 

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Microsoft Access and open the sample database Northwind.mdb.



2. Open the Customers form in Design view.



3. Place the pointer in the Form Header. On the Insert menu, click Hyperlink. The Insert Hyperlink dialog box appears. In the "Type the file or Web page name" text box, type http://www.microsoft.com, and then click OK.



4. Click the Form Header section again to move the focus from the hyperlink text. On the Format menu, click AutoFormat. In the AutoFormat dialog box, under Form AutoFormats, select Standard, and then click OK. The link now appears in black.



5. On the Format menu, click AutoFormat again. This time select Blueprint, and then click OK. The link now appears in blue.

REFERENCES

For more information about the ForeColor property, click Microsoft Access Help on the Help menu, type ForeColor property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: prb

Keywords          : kbdta IntLink 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: July 15, 1999