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