William Benson (VBACreations.Com)
vbacreations at gmail.com
Tue Jun 21 20:49:09 CDT 2011
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?