I have a column in a table, where I need to be able to differentiate between uppercase and lowercase without getting a duplicate error message.

The table has only two columns.

The first must be a text value, represents the primary key, and is only one character in length. It must support lowercase and uppercase, recognizing them as different values, where "z"<>"Z". What MS Access solution is there to this?

Please help with a solution!!!

The only way I know to force VBA to see the difference between "z" and "Z" is to look at the ascii value of each character. The way you look at the ascii value of a character is to use the asc method as seen below:

asc("z")
asc("Z")

If you need to use an if statement to compare the "z" and "Z" then try this:

If (asc("z") <> asc("Z")) then
    blah, blah, blah
End If

Another option is to store only the ascii values in your table, then you will have numbers to compare and when you need to see what character that ascii number is you just use the chr method as seen below.

Dim strCharacter as String
strCharacter = chr(122)

122 is a lower case z and 90 is an uppercase Z.

donrafeal