Text Field : Difference between Upper and lower case

  • Thread starter Patrick Garceau
  • Start date
P

Patrick Garceau

Is it possible to create inside a table a text field with a primary key that
would make the difference between
lower case and upper case

ex.: Bas, bas, bAs

In this example I would have 3 records, but in reality, after the first
entry i get a duplicate entry error

Is it possible?

Thanks

Patrick
 
J

John Vinson

Is it possible to create inside a table a text field with a primary key that
would make the difference between
lower case and upper case

ex.: Bas, bas, bAs

In this example I would have 3 records, but in reality, after the first
entry i get a duplicate entry error

Is it possible?
Click to expand...

Unfortunately, no. Access (JET) indexes are simply not case sensitive.

About the only getaround is to use a formally redundant field
containing the Hex expansion of the text field, as a text string, and
make *it* the Primary Key.

John W. Vinson[MVP]
 
P

Patrick Garceau

Nice thinking, i just need the primary key to be twice the length of my text
fields
and check for update error of my primary key

Good

Pat
 
J

John Vinson

Nice thinking, i just need the primary key to be twice the length of my text
fields and check for update error of my primary key

Good
Click to expand...

Well, no, it's not very good: you're exactly correct, there's overhead
in storage and the need to check for update anomalies.

As I say - not good, but the best you'll get, I fear!

John W. Vinson[MVP]
 
K

Kevin

Patrick,

Before you store your record, could you not force the primary key field data
to all uppercase or all lowercase, then store the converted value? Not sure
how to do this offhand but I am fairly sure there is a way.

Hope that helps!

Kevin
 
Top