Access changes cafe to café

[ClydeData]

I have a small problem with access changing cafe to café automaticaly with the french accent é

I have checked all regional language settings and everthing seems OK, but in both table and form fields e is changed to é in the word cafe.

Where it crates a problem is when I want to do an import into SAGE, sage does not like Cafe spelt with an é

Thanks

Jimmy

 

[Remou]

Turn off the autocorrect 'feature'.

 

[genomon]

I the database window click on "Tools", then "Autocorrect". I'll bet you have the correction preset there - just delete or uncheck it.

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[Remou]

genomon
I do not think that is it. I think café is a spelling thing, like cliché and it is Allow Autocorrect that needs to be turned off (set to No).

 

[missinglinq]

You can either turn off the spelling part of AutoCorrect (uncheck "replace while typing") or you can scroll down the word list, select "cafe", click on Delete and click OK. This leaves spelling correction on but won't correct "cafe."

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Remou]

Won't the second option leave blasé, crème, cliché etc, should the need to use any of these words occur? Also, won't deleting options from the autocorrect list affect other programmes where the corrected item may be required?

 

[genomon]

Remou is probably right - moot point here since most of our data is numbers.

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[ClydeData]

Thanks problem solved.
Must investigate if the autocorrect is common to all of MS office.
But deleting cafe to café has solved the immediate problem.

The database giving the problem was a catering one so cafe/café appeared fairly frequenly.

Thanks Again

Jimmy

 

[Remou]

Must investigate if the autocorrect is common to all of MS office.

It is.

 

[WildHare]

Remou: It is.

And since Office uses a SHARED autocorrect dictionary, it will no longer be 'corrected' in a Word document, Outlook, etc etc etc.

I'd rather turn off autocorrect in the TOOLS/OPTIONS of Access, than remove it from the dictionary.

Plus, if I remember, AUTOCORRECT tosses in a lot of overhead when it's usually not all that required in a database environment, unless you have a LOT of text/memo data.

--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman