Connie-
Option Compare Database sets your code to use non-case sensitive compares for
text (string). "A" = "a"
That's what the query engine uses, and it's good to use that unless you need a
case-sensitive compare. You can use the StrComp function to override the
default compare.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Wednesday, August 08, 2012 5:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Option Compare Database
Hi all,
Midway through creating the database I made Option Explicit the default. So I
was going to go back and add it too the initial modules. I've noticed that some
modules have both Option Compare Database and Option Explicit.
What does Option Compare Database mean? What determines if it should be used?
Seems like some are recommending using it all the time. If so, should I go back
and add it?
Thanks!
Connie
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar