Bug in Combo Box control

M

Meltdown

Registered User.
Local time
Today, 23:54
Joined
Feb 25, 2002
Messages
472
Hi all,

Struggling with what seems to be a bug in the combo box. Given the list of values below in a dropdown combo, I should be able to start typing a name 'IADT' and the combo should jump to the name I want as I'm typing. However in the list below that doesn't happen for some reason.

As a workaround, I've found that putting my finger on the shift key as I type will allow me to get to the record, but this is not a viable longterm solution for my users.

Does anyone know what is going on here?

How would I mimic the user putting their finger on the shift key programmatically when they begin to type in the combo?

Attached sample db

I Buy
I.B.B.
I.C.E.P.
I.G.S.L.
I.R.M.A.
I.S.I.A.
IADT
 

Attachments

It works fine for me. What version of Access are you using and what Service Pack for Office are you on?
 
I tested this using Access 2003 and 2007 versions, both give the same buggy result on my clients machines and home dev machine.

Sorry, where is the Office service pack info?

Regards
Melt
 
SOS, did you download my sample db, there is an ID in there as well, which I hadn't included in my typed sample data.

Regards
Melt
 
Yes, I downloaded and used on Access 2003 SP1 (they won't let us have SP2 or SP3). And it worked just fine for me - just as you said it should.

In 2003 Office Version info is under the HELP menu item > About Microsoft Access and at the very top of the dialog that shows up.

in 2007 it is here (see this as it is easier than explaining)
 
I'm using Access 2007 SP2 on my home PC.

This doesn't make any sense to me how so many PC's show the error and you're not seeing it. Thanks for your input.

Can anyone else confirm it's working please?

Regards
Melt
 
Hi SOS,

Do you know how I might mimic the user putting their finger on the shift key programmatically when they begin to type in the combo?

Regards

Melt
 
Nope, I don't - sorry.
 
OK, thanks, might put up another question for that.

Regards
Melt
 
Just so you will know, I have downloaded your file and tested it here with both 2002 and 2007.

I have been able to reproduce the issue you have been talking about. If I hold down the shift key while I type the alpha characters, the behavior is as would be expected, however, if i do not hold down the shift key then the first value of "I Buy" is selected and then when I type the period(.) which is the next character for all other values in the list, then it pushes the " Buy" to the right and no other values are selected.

Now to see if there is any fix or what to do the find a workaround.
 
Thanks to ajetrumpet for the solution to this problem, setting the AUTOEXPAND property under the DATA tab to 'off' fixes this problem.

Regards
Melt
 
Must be a regional settings thing, because AutoExpand is SUPPOSED to work exactly as you have stated - where it will automatically suggest based on the letters entered. But yours appears to be reversed of mine (since it worked for me with auto expand on and not off).
 
Try setting the combo box AllowAutoCorrect Property to No
 
Really good to know a solution. Thanks to everyone.
 
Just Access trying to be too clever.
I assume the period was being interpreted as the end of a sentence and inserted a space after it.
 
You must log in or register to reply here.

Similar threads

J
Combo Box to filter and Allow Edits
Replies
4
Views
456
Pat Hartman
P
tmd63
How to use a combo box to filter a forms data
Replies
4
Views
304
Pat Hartman
P
E
Solved Refer to Subform control
Replies
9
Views
481
cheekybuddha
cheekybuddha
R
Delete record in dependent cascading combo box
Replies
4
Views
311
RFreund
R
P
form alignment
Replies
3
Views
245
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom