David McAfee
davidmcafee at gmail.com
Thu Aug 15 14:40:19 CDT 2013
All of my forms have: Option Compare Database Option Explicit at the top. The thing is, there is no code being used. It is all the user's action, right clicking on a datasheet. I guess it can be chocked up to more A2010 ADP weirdness. Soon to be moved into an ASP.Net project, as we are doing this will all of our Access databases. D On Thu, Aug 15, 2013 at 10:47 AM, Charlotte Foust <charlotte.foust at gmail.com > wrote: > The Option Compare line in the code module determines whether the > comparison is case sensitive. I know of no setting (at least in 2013) that > allows you to do it for the entire database, and I don't know that you > would want to. Option Compare Database is case insensitive and Option > Compare Binary is case sensitive within the object the module belongs to. > > Charlotte > > > On Wed, Aug 14, 2013 at 12: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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >