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 &?