Arthur Fuller
fuller.artful at gmail.com
Wed Aug 14 17:55:12 CDT 2013
Hi David, Yeah, there is a flag available that decides what to do in the L/U case situation I forget exactly where it is, but try Big Button, then the Access Options button, and then wander around that screen. I'm pretty sure it's there on that screen. Might require a PageDown or two to see it. Vague I know, but I'm relatively confident that it's there somewhere; and there, once you find it, it leads to two choices: "for this app" and "for all apps". Arthur On Wed, Aug 14, 2013 at 3:42 PM, David McAfee <davidmcafee at gmail.com> wrote: > I had a user call me saying she could not find a customer when filtering by > the account number. > She was able to see the customer in another screen, so she knows it should > show up. > > I asked her for the CustNo, and I filtered the datasheet sub form by right > clicking on the custno field and choosing the appropriate filter menu > items. > > I asked her, over the phone, to do the same. > > When she still wasn't getting the expected results, I figured she was doing > something wrong and went over to her desk. > > She was doing it right. I did notice that she was using lower case letters, > which shouldn't matter. > > I asked her to use all caps. She did and the filter worked! > > I thought, how weird. > > Came back to my desk and it filters in lower case or upper case. > > Is there a setting somewhere that would affect how a filter filters? > > A2007 & A2010. > > Thanks, > David > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Arthur