A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combobox text display error



 
 
Thread Tools Display Modes
  #1  
Old May 1st, 2008, 11:35 PM posted to microsoft.public.access.forms
Hoop
external usenet poster
 
Posts: 14
Default combobox text display error

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.
  #2  
Old May 2nd, 2008, 01:36 AM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default combobox text display error

"Hoop" wrote in message
...
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.



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.


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

  #3  
Old May 2nd, 2008, 02:08 AM posted to microsoft.public.access.forms
Hoop
external usenet poster
 
Posts: 14
Default combobox text display error

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.