Hi Everyone,
I'm trying to display an image in a report (once printed) by inserting a blank image control, and setting the source of the image control based on a hyperlink field.
Me!Image243.Picture = Me.Ctlhyperlink
But.....access stores the hyperlink as:
C:\Users\default\Pictures\1.jpg#C:\Users\busin\Pictures\1.jpg#...which then throws up an error when the report's VBA tries to set the source location of the picture.
Is there any way to store the hyperlink as just C:\Users\default\Pictures\1.jpg without the hashtags and the duplicated link?
Or...is there another way to set the image source in the report that I am not aware of?
Thanks very much
I'm trying to display an image in a report (once printed) by inserting a blank image control, and setting the source of the image control based on a hyperlink field.
Me!Image243.Picture = Me.Ctlhyperlink
But.....access stores the hyperlink as:
C:\Users\default\Pictures\1.jpg#C:\Users\busin\Pictures\1.jpg#...which then throws up an error when the report's VBA tries to set the source location of the picture.
Is there any way to store the hyperlink as just C:\Users\default\Pictures\1.jpg without the hashtags and the duplicated link?
Or...is there another way to set the image source in the report that I am not aware of?
Thanks very much