Well, you can't use lcase(field) or Lower(field) like you are. I've been
trying to get this to work but haven't had any luck. I'll post back shortly
if I can make it happen. I know this can't be this hard.
Ok, instead of using the functions (which may work but I'm stumped), if you
set the .CaseSensitive Property of the underlying datatable to false, your
filter should work.
Ok, instead of using the functions (which may work but I'm stumped), if you
set the .CaseSensitive Property of the underlying datatable to false, your
filter should work.