Hyperlink Properties.

[Saxman]

I have just created a field on a form which contains a hyperlink. (The
Hyperlink has been chosen on the corresponding table in design view).

If I type in a legitimate email address, and set the properties in the
field as a hyperlink and link it to an email address, all works well by
double-clicking on it, opening up my default email client. However, if I
go to the next record, the corresponding field properties are set to a web
address, http//.....

How can I make every record within the database default to a mailto: link?

Surely I don't have to set the properties for every record?

 

[Ed Robichaud]

Sounds like you've confused web addresses with email addresses. Hyperlink is
a field type that is set in table design. Any valid url entered into that
field/form control will open a browser to that address. Email addresses are
best stored as text fields. Use a form with a bit of "Send to" code to
start a blank email for that specific address. Sample code for the OnClick
event of a text box named "email":
'================================================
Private Sub email_Click()
If IsNull() Then
MsgBox " No address found ! ", vbExclamation, "Missing e-mail"
Else
On Error Resume Next
DoCmd.SendObject , , , Me![Email], , , "Reston Bike Club"
End If

If Err.Number = 2501 Then
MsgBox " Email message cancelled ", vbExclamation
End If

Exit_Email_Click:
Exit Sub

Err_Email_Click:
' MsgBox " Email message cancelled ", vbExclamation
MsgBox Error$
Resume Exit_Email_Click

End Sub
'===================================================
-Ed