Cannot assign Rs.Fields("id") to the TextToDisplay property of a hyperlink.

[Ragnaros]

This works:

ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(1,1), Address:="", SubAddress:="'SheetID50'!B1", TextToDisplay:="50"

But how come this doesn't work?

ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(1,1), Address:="", SubAddress:="'SheetID50'!B1", TextToDisplay:=Rs.Fields("id")

The problem is with the Rs.Fields("id") at the end of the statement. I thought that it had something to do with the quotes, so I assigned Rs.Fields("id") to a variable and then tried this:

ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(1,1), Address:="", SubAddress:="'SheetID50'!B1", TextToDisplay:=MyIDVar

..but that didn't work either. Any idea why?