VBA Access Arguments Passing Values
<p>Access 2013</p>

<p>I'm calling a formula to modify a string and it's changing the values w/in the parent sub.</p>

<p>Example:</p>

<pre><code>Debug.Print Str 'Hello World my name is bob
BOBexists = InStringChceck(Str,"bob")
Debug.Print Str 'HELLO WORLD MY NAME IS BOB
Debug.Print BOBexists 'TRUE
</code></pre>

<p>I've used this function, InStringCheck, in Excel VBA before (and it's just an example, all of my string tools are doing this same thing now and I don't know why)</p>

<pre><code>Function InStringCheck(Phrase as string, Term as string) as Boolean
    Phrase = UCase(Phrase)
    Term = UCase(Term)
    if instr(1, Phrase, Term) then InStringCheck = True else InStringCheck = False
end function
</code></pre>

<p>In several of my functions I manipulate the input variables, to arrive at a solution, but I don't want those manipulations to persist outside of the function unless I pass them back up - some how they're being passed up, but they're <strong><em>not dimed as public variables</em></strong></p>