case sensitivity Import versus input

[Dion van Overdijk]

When ceating a database and setting validation rules for a text field where
the required value is either: living area or study or bedroom so access
accepts this in the validation rule as "living area" Or "study" Or "bedroom".
When now importing a csv file were this field contains any other value than
these three specified they get rejected (good) but also if the values in the
csv files are Living area, Study or Bedroom rejecting will occur.
However when putting data in manually in datasheet view the case sensitivity
suddenly doesn't seem to exist anymore!
Anybody any idea?
Yours faithfully
Dion van overdijk

 

[Tim Ferguson]

"=?Utf-8?B?RGlvbiB2YW4gT3ZlcmRpams=?=" <Dion van
(e-mail address removed)> wrote in

if the values in the
csv files are Living area, Study or Bedroom rejecting will occur.
However when putting data in manually in datasheet view the case
sensitivity suddenly doesn't seem to exist anymore!

I haven't come across this: deserves extra investigation.

In the meantime, setting the validation rule to

LIKE "living area" OR LIKE "study" OR LIKE "bedroom"

would be a quick fix for the problem.

Hope that helps


Tim F