case-sensitive case-sensitive TJVFree (TechnicalUser) (OP) 4 Nov 15 22:07 I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access. Thanks TCB RE: case-sensitive dhookom (Programmer) 5 Nov 15 01:11 You may be forced to always use StrComp() Duane Hook'D on Access MS Access MVP RE: case-sensitive strongm (MIS) 5 Nov 15 08:19 Access is inherently case-insensitive, so dhookom's suggestion is probably the best option. RE: case-sensitive Darrylles (Programmer) 22 Nov 15 08:51 Sorry, I know that this is an 'horse already bolted' solution. However, wherever possible (and I know that this is usually due to inheriting responsibility of 'legacy' databases); whenever I create a database, I ensure that data is stored in the case format that I meed it to be OR update the data to be that format (this is generally only a very small sub-set of the data anyway). I'd much rather solve the underlying issue once, as, if this data was exported elsewhere - would it not take this issue with it? ATB, Darrylle Never argue with an idiot, he'll bring you down to his level - then beat you with experience.