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.

 

[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!