<div>
I'm not sure where or why you're getting that error, but you can use Replace - <br />
<br />
Replace(StringOrField, &quot;&lt;&quot;, &quot;&quot;)<br />
<br />
You're replaceing &quot;&lt;&quot;&nbsp;with &quot;&quot;&nbsp;(empty/nothing)
</div>


I'm not sure where or why you're getting that error, but you can use Replace -

Replace(StringOrField, "<", "")

You're replaceing "<" with "" (empty/nothing)

<div>
I actually want to keep the &quot;&lt;&quot;&nbsp;and place that in a field. &nbsp;In the above code, if &quot;&lt;&quot;&nbsp;is present, then it is stored in control Text863.
</div>


I actually want to keep the "<" and place that in a field.  In the above code, if "<" is present, then it is stored in control Text863.

<div>
This &quot;InStr&quot; function was the key to this one.
</div>


This "InStr" function was the key to this one.

<div>
<div class="content wysiwyg-content">
I have a 2010 Microsoft Access database which has the following code that parses a text field: &nbsp;<br />
<br />
&quot;TROPONIN-I/CTNI &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;0.03 &nbsp; &nbsp;ng/mL&quot;<br />
<br />

<pre><code id="code-10-28162224-1">s = Split(LabPaste, &quot;TROPONIN-I/CTNI  &quot;)
If UBound(s) &gt; 0 Then
strLab = Split(Trim(s(1)), &quot; &quot;)(0)
strLab2 = Split(Trim(s(1)), &quot; &quot;)(1)
If (strLab = &quot;&lt;&quot; Or strLab = &quot;&gt;&quot;) Then
Text863 = strLab
Text657 = strLab2
Else
Text863 = &quot;&quot;
Text657 = strLab
End If
Else
End If</code></pre>
<br />
The problem is that I get an error because there is no space between the &quot;&lt;&quot;&nbsp;and the &quot;0.03&quot;. &nbsp;I need to trim off the &quot;&lt;&quot;&nbsp;somehow and return only &quot;0.03&quot;<br />
<br />
Any help would be greatly appreciated!
</div>
</div>


I have a 2010 Microsoft Access database which has the following code that parses a text field:  

"TROPONIN-I/CTNI                                   <0.03    ng/mL"

(CODE)

The problem is that I get an error because there is no space between the "<" and the "0.03".  I need to trim off the "<" somehow and return only "0.03"

Any help would be greatly appreciated!

Trimming characters

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.