Hyperlinks in fields

[gacapp]

I have a question hopefully someone can help...

I have hyperlink fields setup in Access. In those fields are paths to photos that I am using for inventory. So for example I have a path \\inventory\2018\picture1.jpg

My question is - is there a way to setup the part of the path for the photo in the fields design, so when I go to enter the photo name in the field, I only have to enter picture1.jpg? So in this case, can \\inventory\2018 be setup in the field so I don't have to type it every time?

Any help would be much appreciated.

[June7]

I don't use hyperlink field type. I use simple text field then code runs FollowHyperlink command. Or for more info on opening hyperlinks review http://allenbrowne.com/func-GoHyperlink.html

Are you using Image control to display images in Report? The image path in ControlSource can be an expression that concatenates text with field. So all that is needed in the field is the image name and static path can be literal text.