<div>
<pre><code class="code-1 nolinks" id="code-20-42051087-1"><span>Application.FollowHyperLink(&quot;TheValueofTheTextField&quot;)</span>
</code></pre>
</div>


<div>
instead of clicking on the text control to open (because might they not want to edit it?) - perhaps a little &quot;Open&quot; button after the text control? In that case, the code that John gave you would go in the Click event.<br />
<br />
To create the procedure:<br />
1. click on the control in design view (for instance, make a new button with a good Name) <br />
2. on the Property Sheet, click in the Event you want to create<br />
&nbsp;- for a button, this is usually the CLICK event (which is labeled 'On Click' in properties)<br />
3. Press &quot;[&quot; to select [Event Procedure]<br />
&nbsp;(from the drop-down list, which also includes available macros)<br />
4. Click on the Builder button (...) to the right<br />
5. this takes you to VBA right where you need to be to paste the code and then customize it for your names.<br />
<br />
when done, Debug, Compile from the menu, then Save. Then test
</div>


<div>
I like the button method. &nbsp;But it isn't working. &nbsp;Here is my code:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42051112-1"><span>    Dim strFileName As String</span>
<span></span>
<span>    strFileName = Me.txtLocationPathandLink.Value</span>
<span></span>
<span>    Application.FollowHyperlink (&quot;strFileName&quot;)</span>
</code></pre>
</div>


<div>
when you use the name of a variable for the argument, do NOT enclose with quotes. Quote marks mean, literally, use this value. You want the value to be what is assigned to the variable. 
<pre><code class="code-1 nolinks" id="code-20-42051121-1"><span>Application.FollowHyperlink strFileName&quot;</span>
</code></pre>
</div>


<div>
You want the value to be what is assigned to the variable, not the name of the variable because, of course, that is NOT a path and filename ... <br />
<br />
Parentheses can be used, or not, around the argument, in this case.
</div>


<div>
<div class="content wysiwyg-content">
I have a form that contains a text field. &nbsp;In the text field, for example, might be &quot;Q:\Docs\Qpub\1234567.890.<wbr />pdf&quot;. &nbsp;When the user clicks on the text field I want the file designated in the text box to open.<br />
<br />
Note: &nbsp;In most cases it might be a pdf file but in other cases it could be a Word doc or an Excel file.<br />
<br />
How can this be done?
</div>
</div>


I have a form that contains a text field.  In the text field, for example, might be "Q:\Docs\Qpub\1234567.890.pdf".  When the user clicks on the text field I want the file designated in the text box to open.

Note:  In most cases it might be a pdf file but in other cases it could be a Word doc or an Excel file.

How can this be done?

How open a file when clicking on a text field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.