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