ACC97: Using AutoFormat Changes Appearance of Hyperlinks

• Microsoft Access 97

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 will be 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. Using the right mouse button (right-click), click the hyperlink control, and then select Properties.



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, select 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 "Link to file or URL:" list 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 Dusk, and then click OK. The link now appears in yellow.

REFERENCES

For more information about the ForeColor property, search the Help Index for "ForeColor Property," or ask the Microsoft Access 97 Office Assistant.

Additional query words: prb

Keywords          : IntLink 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: April 30, 1999