case-sensitive

[TBC]

I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access.

Thanks

 

[spikepl]

"don't look the same " where exactly. Supply the context in which you wish to discern

 

[Galaxiom]

Assuming you want a Where clause to detect the difference.

Use the VBA StrComp() function with the third parameter as 0. Same applies to InStr().

 

[gemma-the-husky]

note that in vba there are alternative options to

"option compare database" that also affect string testing.

 

[Galaxiom]

note that in vba there are alternative options to

"option compare database" that also affect string testing.

The alternative, Option Compare Binary, will cause code in that module into case sensitive comparisons but it won't affect the built-in StrComp and InStr functions.

You could go to the trouble of making a case sensitive version of these functions in a public module so they could be used in the database but adding the third parameter to the existing functions seems a lot easier.