Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Angry Unanswered: XP Spell Check Question

    I have a macro using runcommand:spelling that upon exiting a text box spell check for the current record is completed automatically.

    It works wonderfully in Access 2000, but in Access XP it goes to the first record when all I want to do is stay in the current record.

    Anyone else have this problem and if you go past it how did you do it?


    jacque

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    If the spell check actually carries out its' job on your current record but then jumps to the first record when exiting, then perhaps force access to GoTo your current record again (it must be issuing a Requery).

    Store the current record number into a Long Integer Variable then after the spell check, issue a DoCmd.GotoRecord blah, blah .

    But...If the GotoRecord function is fired while the spell check is displayed, then perhaps create a global Flag (Public SplChk As Long), before the spell check is fired set the flag (SplChk = currentRecordNumber). Then in the form's Current event place something like:

    If SplChk > 0 Then SplChk = 0: DoCmd.GotoRecord blah, SplChk


  3. #3
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81
    If nothing else works I may have to do this.

    But as time goes on, and the database gets larger it may become a bit of an issue.

    Thanks for the reply.

Posting Permissions

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