PDA

View Full Version : Access is correcting a name incorrectly



Qubit
04-09-2008, 11:22 AM
Hi all.

I have a customer in my MDB file (and Simply Accounting) having the name DESIGN DECOR.

I have a routine that grabs the Customer Aged Report that I export from Simply Accounting, and using the name data, updates my customer's aging fields.

In Simply, the customer is defined as above.

In Access, when I type the name, Access helpfully changes it to DESIGN D?COR (with the e-grave), thinking it knows better.

I can circumvent by adding a period to the name, but don't want to.

Does ANYONE know how I can stop this behaviour? Name AutoCorrect is off.
Furthermore, the only way I could enter this in Simply is to copy/paste from Access - I don't have an ? key.

I appreciate any help for this most annoying nit.
.Q

Trevor
04-09-2008, 12:03 PM
Check this link out, you may need to on change of the textbox you enter the name into add a format argument
http://www.pcreview.co.uk/forums/thread-1306573.php
hope this helps, Trevor

Carl A
04-09-2008, 01:54 PM
Quibit:
I don't know what to tell you. I tested this in Access 2000 and 2007 and setting Allow AutoCorrect to No prevents the acute accent from appearing.

Trevor
04-09-2008, 03:50 PM
Carl, I think it has somthing to do with the keyboard mapping and country, language, check the link out I posted