IJ is converted into Ij

[Manuel10]

Hello,
I have table column for normal textfields. For some unknown reason to me Access changes words that starts with the capitals IJ into Ij. For example: the dutch word IJsbergla becomes Ijsbersla. Other capitalcombinations like RObot or BEker are not converted. Why does this only happen to the IJ-combination, and how can I prevent it? I have not been able to find a solution yet.
Thanks! Manuel Buys.

 

[RuralGuy]

Have you looked under Tools>AutoCorrect Options...

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[Manuel10]

RuralGuy,
Excellent!! I can even put in exceptions so that the AutoCorrect option does not need to be turned off.
I realised that it hat to be a bug, or something simple. But it somehow never came to mind to look at other setting options in Access.
Thank you very much!
Manuel.

 

[RuralGuy]

Glad I could help.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[Manuel10]

I've had this problem for years now. It was never a major issue, so I let it be. But now that is is finally resolved it is sort of 'the cream on the pie'.
Though it's more important that all the programming works correctly, it is very satisfying to have these details resolved. So thanks again.
Regards, Manuel.

 

[RuralGuy]

In my case, one of the client names to enter was "Tothe". Access kept changing it to "To the" and it drove me nuts until I figured out what was causing the issue. We all have to learn somehow. Enjoy.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[Manuel10]

I understand you had a similar situation. Great that you figured it out (and kept your sanity ;-).
Yes, with programms like Access you simply never stop learning. That is fun, but sometimes also a bit frustrating.
Regards, Manuel.