I have some textboxes on a form that list between 0 and 5 comma separated items. I want to have it that each of the items is a hyperlink.
Ive tried searching for a solution on this and every reference to it says that you shouldnt store multiple pieces of data in one field. I know this and I dont store them like this. The textboxes are populated when a record is selected and the items are stored individually in another table. Is there anyway to do this?
I played about a little with the table that has the individual items in it and added a hyperlink field. I was able to get it from the table to show the item name, but link to the page I wanted it to. I then changed the textbox on the form to grab from the hyperlink field instead, but it ends up coming out as ItemName#Hyperlink#, ItemName#Hyperlink# and neither of the two items are actually hyperlinks.
I was also trying to see if I could make the textbox a richtextbox instead, but apparantly that is only a vb object and cant be used on an access form