The letter "I" is a problem?!

Posted on 2007-10-09
Last Modified: 2013-11-28
Access form question.  Any time the letter "I" is used as the first character in a search, an error occurs that says it can't move the focus to the control.  How do I avoid this?
Question by:JimFaull
    LVL 7

    Expert Comment

    Taking the wording of the question, I'm inclined to say: "don't use letter I as the first character in search" :)

    But, realistically, could you be a bit more specific, what does "search" mean in this context?
    LVL 77

    Expert Comment

    Which version of Access?
    Exactly how are you doing the search?

    Author Comment

    That's what I said, too!

    To be more specific, I am using Access 2000 runtime.

    Private Sub txtFindSong_Change()
        Dim ynBlank As Boolean
        Dim lngRet As Long
        Application.Echo False
        If Right(Me!txtFindSong.Text, 1) = " " Then
            ynBlank = True
            ynBlank = False
        End If
        Select Case Me!optSort
           Case 1 'Title
            Case 2 'Key
            Case 3 'BookName
        End Select
    '   Me!txtFindSong.SetFocus
        If Len(Me!txtFindSong) > 0 Then
            DoCmd.FindRecord Me!txtFindSong, acStart, , acSearchAll, , acCurrent, True
            DoCmd.GoToRecord , , acFirst
        End If
        lngRet = fSetScrollBarPos(Me, Me.SelTop)
        If ynBlank Then
            Me!txtFindSong = Me!txtFindSong & " "
        End If
        Me!txtFindSong.SelStart = Me!txtFindSong.SelLength + 1
        Application.Echo True

    End Sub
    LVL 77

    Expert Comment

    Are you saying you only get the error when you use the runtime app or are you getting the same error when you are in the development machine as well (in which case which setfocus line is it failing on?)?
    LVL 74

    Accepted Solution


    Set the "Allow Auto Correct" property of this textbox/combox to:

    Access thinks you are typing the Word "I" (First Person Singular).
    So it tries to change "i" to "I"


    Jeff Coachman

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now