Member Avatar for pj.lopez.58

Please Help! I dont know how to use vbDatabaseCompare. I need it for my login form to work!

  • 2 Contributors
  • 1 Reply
  • 115 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

vbDatabaseCompare uses the current setting of the database's string
comparison operator. Normally this will use the computer's language
setting to handle (e.g.) accented characters, and will be case
insensitive. The alternative vbBinaryCompare will compare the exact
ASCII representation of the character. For example:

Instr(1,"XYZabcxZ","x",vbDatabaseCompare)
1

Instr(1,"XYZabcxZ","x",vbBinaryCompare)
7

The first example finds an x (or X) in the first position of the
string, since it's not case sensitive; the second example requires an
exact match, so it finds the lower-case x in the 7th position.

In the Replace() function this would let you choose between replacing
text in a case-sensitive or case-insensitive manner.

Check this site for more info

Edited by Jx_Man
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.