Access 2007: sort by hyperlink?

  • Thread starter Thread starter Mikel Anne
  • Start date Start date
M

Mikel Anne

If you have a table with a column containing hyperlinks, can you sort by that
hyperlink column?
 
Sorry, I sent that before checking on later versions. They could not be
sorted in earlier versions, they can from version 2002 on. I do not have
2000 on my machines at home to check. They cannot be indexed.

A better solution than using the hyperlink datatype, which is inefficient
anyway, is to use a text datatype which can be both sorted and indexed. If
you are using a form, you can use it as a hyperlink by simply
double-clicking with code like:

Private Sub txtBoxName_DblClick(Cancel As Integer)
If Len(Me.txtBoxName & vbNullString) > 0 Then
Application.FollowHyperlink Me.txtBoxName
End If
End Sub
 
Back
Top