[AccessD] Filter text containing ampersand requires apostrophes?

Charlotte Foust charlotte.foust at gmail.com
Wed Jun 22 00:37:57 CDT 2011


The ampersand has mutliple meanings in VBA and in SQL.  Putting apostrophes
around the string tells Access it should interpret the ampersand as a
literal character and not as an operator of some sort.

Charlotte Foust

On Tue, Jun 21, 2011 at 6:49 PM, William Benson (VBACreations.Com) <
vbacreations at gmail.com> wrote:

> When I needed to filter a datasheet subform on a certain field, I ran into
> a
> case where the text filter had an ampersand
>    Florida Power & Light Company
>
> Access refused to find the record when I entered exactly that in the text
> box that comes up when I choose the Equals... menu from the right-click,
> until I put apostrophes around it.
>
> I cannot understand why the Access interface requires apostrophe -- just
> because there is an ampersand in the midst of the string.
>
> I don't think users who are not programmers are going to know about that,
> will they? More likely to conclude the field value is absent?
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>



More information about the AccessD mailing list