Results 1 to 9 of 9
  1. #1
    mcmahont
    Guest

    Problem with Num Lock

    Access 97 - I've been unable to find a solution to a problem I've been struggling with for a while. On a form with numeric and text fields, tabbing from a numeric field to a text field turns the Num Lock off. Tabbing into a numeric field does not turn Num Lock back on.

    From an end user standpoint, this is incredibly annoying since most people assume their Num Lock is always on. My original thought was that the app was corrupted somehow, or that it was an OS issue (I originally saw it on NT Workstation 4.0). However, I've experienced the same issue with multiple Access 97 db's, running on different OS's (NT, W95, W98).

    I have a feeling I'm missing something terribly obvious. If anyone can point it out I'd sure appreciate it!

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Num Lock

    That sounds quite bizarre <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15>. You wouldn't happen to have an Event in the property of the text field something along the lines of SendKeys "{Numlock"} would you ? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Num Lock

    I've had the same problem when rebooting a PC the num lock was defaulting to not on. I think it was within Windows 95 but can't be certain.

    I think I got round it by sendkeys on opening the database somehow.

  4. #4
    mcmahont
    Guest

    Re: Problem with Num Lock

    Don't have any SendKeys events that could cause this. I have tried using SendKeys to fix it though (turn the Num Lock on when moving to a numeric field), but it gets ignored.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Num Lock

    Sounds very suspicious. I wonder if it's not Access at all but some system wide problem. Can you reproduce it TABing in Word for example ? I've had WinDohs suddenly interpret CTRL and TAB in weird and wonderful ways but re-boot always solved the problem.

  6. #6
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Num Lock

    Num lock is usually set at the bios level - press F2, F10 or whatever key gets you into your computer set up when you first start it up. Scroll through the menus until you find something that looks like 'Num', and set the default to 'On'. Save the changes, and continue with booting up.

    Just be aware that messing with the setup _can_ cause problems if you don't know what you are doing, so ask your nearest computer whiz to help if you need it.

    Finally, sorry if this is stuff most people know!

    kiwi44

  7. #7
    mcmahont
    Guest

    Re: Problem with Num Lock

    Problem with the system-wide theory is that that happens on many different computers, at different client sites, under different OS's.

    It's also odd that the SendKeys event to turn Num Lock back on is ignored.

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Num Lock

    I think I've had this problem when using the > or <. This will force the text field to either all upper or all lower case depending on what you use.. This is usually set in the default value of the text field on a form or in the default value of the underlying table. If this is set try removing it.. It may solve your problem..

  9. #9
    mcmahont
    Guest

    Re: Problem with Num Lock

    I ran across the solution to this on AccessWeb. They refer to a "well-known" bug with SendKeys in all versions of Access that can turn the NumLock off. I got rid of the SendKeys references I had (sloppy coding anyway), and the problem has gone away.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •