case sensitivity

[jennypsion]

Hello,
I am designing a database but I have a problem because Access doesn~t seem to allow case sensitivity.
I have a field containing the component names and a field containing the connector names. The components have connectors named a and A, but it doesn~t allow me to enter a and A because it is not case sensitive. Is there a way to get round this?
Thanks in advance.
Jen

 

[Remou]

Hi
This thread705-909179 has some notes on case sensitivity and access, so it may help.

 

[BobStubbs]

I am not sure why this is happening ... can you provide more details, e.g. your Access version, where this is happening (in a table, in a text box or combo box on a form, when sorting?);

Is the field the primary key, is it indexed, etc.



Bob Stubbs

 

[willir]

The top of the module supporting the form, you need to have...

Option Compare Database
Option Explicit[COLOR=blue]
Option Compare Binary[/color]

The binary compare will differentiate upper and lower cases.

Richard

 

[PHV]

The binary compare will differentiate upper and lower cases
In VBA code, not in SQL code.