Hyperlink ID on subform datasheet view to form open


I'm trying to enable the ID field within a subform in datasheet view to be a hyperlink where if the user clicks the hyperlink it opens the details page for that record.

I've set Macro up for the field and done an 'on click' event and it works in form view but in datasheet view the field remains as text.

Is it possible from datasheet view to do this?

Many thanks

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Why not use continuous forms and make it like datasheet...it will give you extra functionality and with a bit of work it would be more eye catching
eyeisystemsAuthor Commented:
It turned out to be some wayword issue with displaying the current ID column, i deleted the column from the form view, readded the ID column and then added the Macro to the newly added column and it worked!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
eyeisystemsAuthor Commented:
I found the resolution myself, it seemed to be an issue with the field within the column, for whatever reason i couldnt add it to the datasheet view (using add existing column) and it wasn't locked. The easiest way to do it was to delete the field off the design view of the subform and readd the ID field in again and recreate the macro against it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.