News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Error 2185 with Text property (Access 2013)

    Posted on WSSimonC Comment on the AskWoody Lounge

    Home Forums AskWoody support Productivity software by function MS Access and database help Error 2185 with Text property (Access 2013)

    Tagged: ,

    Viewing 1 reply thread
    • Author
      Posts
      • #1767034 Reply
        WSSimonC
        AskWoody Lounger

        I’m sure this came up on the old forum, at least in some form, but I can’t as yet find it here.

        There’s a bug in Access whereby the Text property of a ComboBox or TextBox control is inaccessible (even when the control in question currently has the focus) if the control is in the form footer (or header, I think) and the detail part of the form is currently displaying no records. The error raised is 2185, “You can’t reference a property or method for a control unless the control has the focus.”

        In a ComboBox in a particular subform, I was hoping to implement some functionality along roughly the same lines as Allen Browne’s Combos with Tens of Thousands of Records. Ideally I would prefer to have the various input controls (including the ComboBox) in the form’s footer rather than in the form’s detail section, but the inability to access the value so far input (via the combo’s .Text property) is a serious problem.

        Are there any known workarounds to the issue with the .Text property?

         

      • #1809208 Reply
        orangehat
        AskWoody Lounger

        Have you tried <span class=”comment-copy”>cardno = cardnumber</span> instead of <span class=”comment-copy”>cardno = cardnumber.text?</span>

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Error 2185 with Text property (Access 2013)

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.