Hyperlink

[kitty77]

I have two fields that are hyperlinks. I can't do a sort? It's grayed out. Why and or how can I get around that?

Thanks...

 

[theDBguy]

I just gave it a try; and although I couldn't use the built-in sort and filter dropdown for sorting, I was able to create a query and sort on the hyperlink column. Hope that helps...

 

[kitty77]

I just gave it a try; and although I couldn't use the built-in sort and filter dropdown for sorting, I was able to create a query and sort on the hyperlink column. Hope that helps...

Hmmm... I am using a query and my built-in ascending and descending are still grayed out.

 

[Pat Hartman]

Hyperlink is one of the data types I avoid. It is not available in SQL Server and so I don't use it. It is one of those "helpful" data types. Access is storing TWO pieces of information in one field. In reality, they probably use a hidden field for one of the fields and the magic happens as part of the display/edit process.

I use plain text fields. If I want a nice name for the link, I create a second field and use that as a label. That solves the sorting problem.

 

[theDBguy]

Hmmm... I am using a query and my built-in ascending and descending are still grayed out.

Right, same here. What I was saying is that you can sort your hyperlink field by using the ORDER BY clause in your SQL statement. It looks like the built-in UI is restricted from using hyperlink fields for sorting. So, if you have a form where you need to sort the records using a hyperlink field, you will probably have to use the OrderBy property, using code.

 

[kitty77]

Right, same here. What I was saying is that you can sort your hyperlink field by using the ORDER BY clause in your SQL statement. It looks like the built-in UI is restricted from using hyperlink fields for sorting. So, if you have a form where you need to sort the records using a hyperlink field, you will probably have to use the OrderBy property, using code.

Got it. Thanks!