combobox text display error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hoop - 01 May 2008 23:35 GMT

Anyone come across this? With capslock on, typing into a combobox after a few
letters are typed in, the text in the combobox fleshes itself out, but not in
the normal way.

The normal way is for Access to display in the combobox the first entry in
the list that starts with the letters typed in by the user eg type in "ha"
and the text in the combo box might display "Hackett Craig" if that is the
first entry in the list that begins with the letters "ha".

But what's happening in this situation is after "ha" is typed in, the "w" is
typed in (so the first 3 letters typed in are now "haw", the text displayed
in the combobox is "HaWckett Craig" - and there is no such name in the combo
box list.

However, there ARE names in the list beginning with "haw" but these are not
automatically displaying, which you would expect them to. Wierd.

Reply to this Message

Dirk Goldgar - 02 May 2008 01:36 GMT

> Anyone come across this? With capslock on, typing into a combobox after a
> few
[quoted text clipped - 18 lines]
> not
> automatically displaying, which you would expect them to. Wierd.

I haven't seen anything like that. What version of Access?

I would look for code running in the combo box's Change event, or KeyPress,
KeyDown, or KeyUp. Another possibility is something happening in the form's
Timer event, if that is enabled.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Hoop - 02 May 2008 02:08 GMT

> I haven't seen anything like that. What version of Access?
>
> I would look for code running in the combo box's Change event, or KeyPress,
> KeyDown, or KeyUp. Another possibility is something happening in the form's
> Timer event, if that is enabled.

Access 2003 SP2. Nope, no code for any events at all for the control. Its on
the main form and there are also two subforms on that form, whose queries use
what's in the combobox as a parameter, so they dont directly "touch" the
combo box either.

Also, it only occurs when the CAPS LOCK key is on.

Yeah I know its odd, first time I've seen it either. Stranger still its
happening on some workstations and not others, even if the full Access
version number and service pack level is identical, and hardware originally
all bought to same specs and in same batch.

The front and back end are on a server but Access isn't installed on the
server, and the workstations all have shortcuts loading Access up locally on
the worksation with the front end on the server as the mdb to use, (which is
linked to tables in the backened on the server).
I've got them checking the state of Windows updates, service packs hotfixes
etc for each different workstation. Best I can think of at the moment.

Reply to this Message