Hyperlink returns the value with a leading # and ending # on a form

[emassey0411]

I have been searching for the way to fix this issue.



I am pulling in a hyperlink from a table into my form but when I view the form Access is adding a '#' to both the front and end of the hyperlink. How do I get rid of this? I am using the following to get the associated hyperlink based on what is selected in a different field.

=[PRISONLIST].[COLUMN](8)

Sorry if this has been asked and answered before. I have looked but seriously can't find it.

If I need to add something to the code above please include where (and how to get there) to do it.

thank you again.

[June7]

Field combobox column is pulling from appears to be a Hyperlink type. That is how Access structures hyperlink string. Set the textbox IsHyperlink property to yes.

[Welshgasman]

Is that control based on hyperlink type field?

[June7]

@Welshgasman, no. It has an expression referencing combobox column. Since the column is just text, the expression doesn't know data came from hyperlink field so have to format the textbox.

[emassey0411]

That did it @June7. Thank you so much!!! really appreciate the help