Share via

Problem with ComboBoxes

Anonymous
2023-11-12T11:00:26+00:00

Since a few days ago, I'm experimenting an estrange behavior in my combo boxes with RowSource = SELECT DISTINCT [sometextfield] FROM [sometable].

If the AutoExpand property is set to Yes and the LimitToList property is also set to Yes, the ComboBox behavior is as expected: when I type a few letters, it fills the combo with the first match.

But, If AutoExpand = Yes and LimitToList = No, when I type a few letters, it doesn't fill the combo with the first match.

I'm using the last 64 bits Microsoft 365 version for Education.

Any hint?

Microsoft 365 and Office | Access | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2023-11-15T18:22:05+00:00

    Was this answer helpful?

    0 comments No comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-11-14T15:30:06+00:00

    Was this answer helpful?

    0 comments No comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-11-13T14:07:55+00:00

    The Access team is aware of the problem and is pursuing a fix for it. I'll follow up when we learn more.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-11-12T23:08:46+00:00

    Microsoft® Access® para Microsoft 365 MSO (versión 2310 compilación 16.0.16924.20054) de 64 bits

    Thanks for your quick response.

    Was this answer helpful?

    0 comments No comments
  5. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-11-12T13:16:00+00:00

    Similar problems have been reported to the MS Access team.

    Please provide the build no for your MS 365 version.

    Was this answer helpful?

    0 comments No comments