[AccessD] URL-like label

You can use a label, format the text any way that you want and use its on_click event.

If you want the link to change its appearance when you mouse over it (such as to change its 
colour, make it underlined or whatever) you need to use two superimposed labels and the 
MouseMove event.

Create two labels, one slightly larger than the other. 
Make the caption of the larger one empty
Put your link text in the smaller one (and colour it appropriately if so desired(
.  
Make sure that the larger one is lower in the Z Order (create it first and/or use Format - 
Send to back)
Centre the smaller label in the larger one so that there is an overlap all round.

Then use the following event procedures:
(lblURL is the smaller label and lblURLClear is the larger one)

Private Sub lblURL_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As 
Single)
   lblURL.FontUnderline = True
End Sub

Private Sub lblURL_Click()
DoCmd.OpenForm "frmLinkedForm"
End Sub

Private Sub lblURLClear_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As 
Single)
lblURL.FontUnderline = False
End Sub

-- 
Stuart

On 19 Jun 2009 at 6:28, Arthur Fuller wrote:

> I'm sure I've done this but I cannot remember how and I can't find it in the
> list of controls. I thought that I could create a control that looks and
> acts like a typical web page reference to another page. In this case when
> it's clicked I want to open a form. I suppose I could use a button control,
> but I was sure there was another way. This is Access 2003.
> 
> TIA,
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com