Introduce a non-case sensitive command?

[bralew]

Morning All,

I'd like to make this statement non case sensitive, so it makes no difference whether the 'C' is Capital or otherwise:

Please Login or Register  to view this content.

Any ideas?

[sintek]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[NickyC]

or try this:

Please Login or Register  to view this content.

[kev_]

@sintek
Should it not be?
If Ucase(?) = "C69336"

[sintek]

@ kev_ To be or not to be...Right you are...
So like such?

Please Login or Register  to view this content.

[xlnitwit]

No real benefit to Ucase("C69336") since it's already in upper case.

[kev_]

@sintek
"C69336" is already upper case - so it does not require wrapping in Ucase function - it is not incorrect, just unnecessary
If Ucase(Textbox1) = "C69936" ....
Is same test as
If Lcase(Textbox1) = "c69936" ....

[bralew]

Thanks All,

I've pasted 'Option Compare Text' at the top of my user Forms, of which there is 7, which works great. It's obviously better to paste it into a module which will then affect all the user forms?
However, I have 5 modules, does it make a difference which one I paste it into? Or should I take all the information from the modules and paste them into 1 module?

Cheers

[sintek]

@ kev_ & xlnitwit
Of course...Thanks

[xlnitwit]

I've pasted 'Option Compare Text' at the top of my user Forms, of which there is 7, which works great. It's obviously better to paste it into a module which will then affect all the user forms?

Option statements only apply to the module they are in, so you would require it in each one. It's more efficient to use LCase$ or UCase$, though I doubt you'll notice the difference in practical terms unless you are performing millions of comparisons.

[bralew]

Thanks xlnitwit. I've read that a module has a 64K limit although this is questioned by some users. Should I put my code into a generic module rather than have them spread out?

What do you prefer?

[xlnitwit]

A module does indeed have a limit of about 64K. Personally I have never got near that limit.

My preference is to group related procedures in the same module and keep common functions (those which are called from many other routines) in their own separate module(s).

[Norie]

Try this.

Please Login or Register  to view this content.