title: How to get hyperlinks dynamically in Microsoft Access Reports?
body: <p>In a MS Access Report, I am trying to create a hyperlink that would take a user webpage. The URL is dependent on a data field in my database. </p>
  
  <p>In my report, I have added the hyperlink control and used the popup to enter the hyperlink. </p>
  
  <p>When I use the Hyperlink Builder, to dynamically set the value of one of the parameters, I get a garbage url that does not work.  The URL that is returned is : </p>
  
  <blockquote>
    <p>file:///C|/Users/gh/Dropbox%20(Bar01%20College)/BW%20Demo%20Project/="https://baruch.az1.qualtrics.com/jfe/form/SV_8uZm3rAnSWPE9gN?DocumentID="
    &amp; [documentID] &amp; "&amp;TransmittedScore=ENG_2100"</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/e4y6V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e4y6V.png" alt="MS Access Edit Hyperlink Popup, Hyperlink with dynamic value that does not work"></a></p>
  
  <p>The expected result would be to have the URL that is customized based on the record where my parameter DocumentID would be equal to the value of my documentID field.</p>
  
  <blockquote>
    <p><a href="https://baruch.az1.qualtrics.com/jfe/form/SV_8uZm3rAnSWPE9gN?DocumentID=ZuluTest&amp;TransmittedScore=ENG_2100" rel="nofollow noreferrer">https://baruch.az1.qualtrics.com/jfe/form/SV_8uZm3rAnSWPE9gN?DocumentID=ZuluTest&amp;TransmittedScore=ENG_2100</a></p>
  </blockquote>
  
  <p>If I paste the expected URL into the address field, the URL parses properly: 
  <a href="https://i.stack.imgur.com/9iyXa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9iyXa.png" alt="MS Access Edit Hyperlink Popup, Hyperlink with static value that does work"></a></p>
  
  <p><em>The requirement of this project is that the links need to be clickable when exported to PDF.</em> </p>
  
  <p><em>Note: I have previously posted this question to <a href="https://www.utteraccess.com/forum/index.php?showtopic=2057701" rel="nofollow noreferrer">https://www.utteraccess.com/forum/index.php?showtopic=2057701</a> and looking for additional assistance.</em> </p>