Chp. 5 pg 91 Top of page - explains VBA default is NOT case sensitive achieved by using the open module command Option Compare Database

In Table presented it shows that Option Compare Database statement results in String comparisons ARE case sensitive.

Below Table - "Unless you have good reason to change the Option Compare statement, leave it as the default value of Option Compare Database.

QUESTION - what is correct - using the default defined above - will this result in NOT CASE SENSITIVE ?

Hello messingerddm,

Thank you so much for reading the Microsoft Access 2007 VBA Programmer's Reference and for posting your questions about it here. Also, I apologize for not getting back to you sooner about this post, I've just noticed the post today, but it is over a month old, so I wanted to respond as soon as possible - my deepest apologies! Specifically, you asked:

So, right off the bat, to answer your question: When "Option Compare Database" is used, string comparisons are NOT case sensitive.

But, maybe there is some confusion here. If I look in the table on Page 91, the "Option Compare Database" definition says:

Specifically noting that it says "INsensitive" (meaning NOT case sensitive). Am I missing something here, or does my answer make sense?

Anyway, I hope that helps, but if you have any more questions about this or other topics, please just let me know and I'll do what I can to help. And thank you again for reviewing the Access 2007 VBA Programmer's Reference, we appreciate your readership!

Thanks again,

__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->