<div>
Try putting the field name in quotes.
</div>


<div>
If you mean you are using SQL strings to query your backend try...<br />
<br />
SELECT * from tblCompanies WHERE tnlCompanies.CompanyName like 'Benson \&amp; Sons';<br />
<br />
You need to replace all &amp;&nbsp;with \&amp; before your selects.
</div>


If you mean you are using SQL strings to query your backend try...

SELECT * from tblCompanies WHERE tnlCompanies.CompanyName like 'Benson \& Sons';

You need to replace all & with \& before your selects.

<div>
Hello everyone,<br />
<br />
I found my error. &nbsp;It was actually not a &amp;&nbsp;but a / in the name. &nbsp;In my program those are easy to remove and keep the people from putting them in again.<br />
<br />
Thank you all!
</div>


Hello everyone,

I found my error.  It was actually not a & but a / in the name.  In my program those are easy to remove and keep the people from putting them in again.

Thank you all!

<div>
I asked the wrong question actually
</div>


<div>
<div class="content wysiwyg-content">
Hello Everyone,<br />
<br />
I have an access 2010 program that I am converting to work with the backend on the cloud. &nbsp;On one form I have a listbox that when the user clicks on a line the system needs to find the record based on a client ID and client name. &nbsp;Sadly some of the client names have &amp;&nbsp;in them. &nbsp;I am getting a parsing error because of the &amp;.<br />
<br />
Short of changing the &amp;&nbsp;to and for all the clients is there a way using VBA to have it see the &amp;&nbsp;as an &amp;?<br />
<br />
Thanks
</div>
</div>


Hello Everyone,

I have an access 2010 program that I am converting to work with the backend on the cloud.  On one form I have a listbox that when the user clicks on a line the system needs to find the record based on a client ID and client name.  Sadly some of the client names have & in them.  I am getting a parsing error because of the &.

Short of changing the & to and for all the clients is there a way using VBA to have it see the & as an &?

Thanks

How do I read a field with an &amp; in it for SQL

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.

How do I read a field with an &amp; in it for SQL

How do I read a field with an & in it for SQL