The @ and " keys in Access 2003

[Guest]

About 6 months ago i was using Access2003 on my laptop and i noticed that the
" and @ symbols had swapped keys.

Normal if you pressed Shift+2, you get ". I was getting @ instead
ans if you pressed shift+', you get @. I was getting " instread.

It wasnt a major problem so i learnt to live with it. Now my main Desktop PC
has gone the same way and i dont know how i did it. Every other program is
normal. Its just Access2003.

Any idea anyone please??

 

[Guest]

You have American Keyboard set up but I don't see how it can only be Access.

Goto Control Panel and set your regional settings to English, United Kindom

I am not sure about this setting but I think this is where you set things
up. Do a search for keyboard settings but I know this is why the two keys you
mention are in reverse order.
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[Guest]

Mike,

Many thanks for your input. After checking my reginal settings they were
selected to UK which is what you would expect. However i did notice some
shortcuts that you could use. Using left alt and shift keys together, you can
switch between reginal settings.

When i did this in Access all went right. I dont know why it only effected
access, i guess it was because i was using access at the time i accidently
pressed the left alt and shift keys.

Anyhow, many thanks for pointing me in the right direction.

 

[John W. Vinson]

About 6 months ago i was using Access2003 on my laptop and i noticed that the
" and @ symbols had swapped keys.

Normal if you pressed Shift+2, you get ". I was getting @ instead
ans if you pressed shift+', you get @. I was getting " instread.

It wasnt a major problem so i learnt to live with it. Now my main Desktop PC
has gone the same way and i dont know how i did it. Every other program is
normal. Its just Access2003.

Any idea anyone please??

Check your keyboard settings in Start... Control Panel. Your language
settings are certainly different from mine: Shift-2 is @, and ' and "
are on the same key. I don't know why Access would be different from
any other Office application!

John W. Vinson [MVP]

 

[John Nurick]

As others have said, this is caused by keyboard settings somehow being
changed. I have one database in Access 2003 SP2 in which this happens
(usually my standard UK keyboard layout changes to US, sometimes to
French). I've not yet managed to pin it down, but the change seems to be
triggered by opening one form.

When the change happens, it only affects that Access session: other apps
stay as normal. Using the Control Panel "Regional and Language Settings"
applet to remove the US and French keyboard layouts makes no difference:
if I check the control panel after the problem occurs, the US and/or
French layouts have reappeared. I've disabled the keyboard shortcuts to
switch to either of these, so it can't be accidental use of these.
Conversely, using the shortcut to switch to the UK keyboard doesn't fix
the problem.

But the problem does seem to be confined to the one form in the one
database, which is a test database years old that has had large numbers
of objects added and deleted, not to mention many crashes. All this
makes me think it's some sort of corruption.

Can you pin your problem down to one form in one database?