<div>
It may be easier to help you if you show us HOW are you taking what they type and passing it to an sql sentence, or how are you requerying, looks to me that you are concatenating strings instead of using parameters for your query
</div>


<div>
Agree with Joe - this smells highly of corruption. Be sure you've made a copy of your db first, before attempting any repairs.
</div>


<div>
Hello All,<br />
<br />
I tried compacting hoping that was it earlier but no change (it is never the easy was is it :D) &nbsp;Here is some more info (I have it attached). &nbsp;LIke I said, this code runs for every other letter in the alphabet both upper and lower except for lowercase i.<br />
<br />
Thanks<br />
Andy<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/04_w15/1090483/Error-more.docx" target="_blank" class="file-inline" title="Error-more.docx (12 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Error-more.docx</a>
</div>


Error-more.docx

<div>
please echo SelectRBGR &nbsp;using msgbox after typing an 'i' and put it here so we can see what all the concatenation results into<br />
<br />
@DatabaseMX he didnt say he uses LCASE anywhere, he TYPES lowercase i in the textbox and then he gets the error
</div>


<div>
So for example of you type &nbsp;Bi ... and ClientValueHolder contains Bi ... as soon was that is used in the WHERE clause ... you get that error ?
</div>


error3.jpg

<div>
Scott ... this is an ' as you type' thing, so he has to use the .Text Property ... and the text box does have the focus be definition.
</div>


<div>
Sorry to get back so late to everyone, there were some other fires to put out. &nbsp;I am doing the suggestions now and will post as I do them.<br />
<br />
Converting to lowercase did not work. &nbsp;I typed in an uppercase I, it converted it to lowercase and it searched perfectly, but when I started by typing in a lowercase i it crapped out again like before.
</div>


<div>
I just tried the msgboxes and both times they showed that i was typing in a lowercase i.<br />
<br />
This is really really odd I have to say, but so far all your suggestions have been terrific, they are taking me to places I might not have thought of.<br />
<br />
I will keep hacking at this.
</div>


<div>
Something new with this.<br />
<br />
I got a new error 3021. &nbsp;I went to Stackoverflow and found this<br />
<br />
<a href="http://stackoverflow.com/questions/17336316/run-time-error-3021-no-current-record" rel="ugc">http://stackoverflow.com/questions/17336316/run-time-error-3021-no-current-record</a><br />
<br />
It basically was a person using Name as a field name. &nbsp;So I thought that maybe a lowercase i is something reserved. &nbsp;<br />
<br />
Don't know if this means anything for me though
</div>


<div>
Name is a Reserved Word and s/b avoided, as well as words like Date, Time and so on.<br />
But No Current Record ... when exactly did that happen ?<br />
Can you upload a db that reproduces this ?
</div>


<div>
I did not decompile. &nbsp;I am going to give that a shot!<br />
<br />
Thanks
</div>


<div>
Hey Joe,<br />
<br />
I will see if I can upload a database that does this. &nbsp;I am going to try decompiling first and then see if that does it.<br />
<br />
Andy
</div>


<div>
I had to close this out for now. &nbsp;I gave out the points because I really appreciate the help. &nbsp;I am going to revisit this when my employer lets me go back to programming the search feature, right now he wants me to work on a different module.<br />
<br />
Thanks again all!
</div>


<div>
<div class="content wysiwyg-content">
OK this has to be the oddest error I have ever come across. &nbsp;I am using Access 2013. &nbsp;I have a textbox that allows the user to type in a letter at a time in order to shrink the contents of a listbox (so after typing the letter I take what they typed and put it into an SQL where statement and requery the listbox).<br />
<br />
Everything works fine except for the lowercase i. &nbsp;Upper case I works fine, lowercase every other letter works fine. &nbsp;Lowercase i causes an error msg (I have attached a jpg). &nbsp;<br />
<br />
The error message to me looks like it thinks i typed the | symbol.<br />
<br />
I am completely at a loss.<br />
<br />
Thanks<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/04_w15/1090430/error2.jpg" target="_blank" class="file-inline" title="Error produced from lowercase i (29 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>error2.jpg</a>
</div>
</div>


error2.jpg

OK this has to be the oddest error I have ever come across.  I am using Access 2013.  I have a textbox that allows the user to type in a letter at a time in order to shrink the contents of a listbox (so after typing the letter I take what they typed and put it into an SQL where statement and requery the listbox).

Everything works fine except for the lowercase i.  Upper case I works fine, lowercase every other letter works fine.  Lowercase i causes an error msg (I have attached a jpg).  

The error message to me looks like it thinks i typed the | symbol.

I am completely at a loss.

Thanks

Lowercase i crashing my Access program

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.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.