Deactivate the link of lookup-fields! (2010)

Question

On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen.

Of course, we can limit the access of the (user info) list itself, but it's not a nice solution when the user clicks on the lookup field, and lands on a access denied page.

The question is: Is it possible to remove the link from the lookupfield? If yes, how?

Thanks in advance, Markus.

Answer 1

Your best bet would be to remove that field/column from the Public view and all other views where you dont want to see it.

If you still want to see the value, create a calculated column which extracts the value from the lookup column and displays that. use the =TEXT calculated column

Hope this helps.