Access 2007 What is up with correcting my spelling when I put data in a field?

[Charles May]

Why on earth would a database (storage device) ever want to correct the
spelling of something I put into it?

Here is my problem.

I created a table with a field as a test for someone and in one of the rows
I entered a field with the word Cafe

When I queried the database to find all instances of the word 'Cafe' I found
0 results.

When I went back into the table to see what was going on, I discovered that
the data in the field was change to Café

This to me makes no sense. And even if I can turn off spell checking, why
would anyone change the information I'm telling it to store?

Thanks for any insight anyone might have on this.

Charlie

 

[fredg]

Why on earth would a database (storage device) ever want to correct the
spelling of something I put into it?

Here is my problem.

I created a table with a field as a test for someone and in one of the rows
I entered a field with the word Cafe

When I queried the database to find all instances of the word 'Cafe' I found
0 results.

When I went back into the table to see what was going on, I discovered that
the data in the field was change to Café

This to me makes no sense. And even if I can turn off spell checking, why
would anyone change the information I'm telling it to store?

Thanks for any insight anyone might have on this.

Charlie

This has been a feature in Office ever since I can remember.
It's very simple to work around.
Either....
1) Change Tools + AutoCorrect Options so that replacing Cafe with Café
does not occur, leaving all of the other changes alone.
This affects all Office programs.

2) Set the control's Allow AutoCorrect property to No.
This affects just this one control.