[AccessD] Combo Box not Autocompleting

Beach Access Software bchacc at san.rr.com
Sun Dec 3 23:06:21 CST 2006


Well, it was a pure shot in the dark.  Even a blind squirrel finds a nut
once in a while.

How about the bound column?  Anything out of the ordinary there? 

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Sunday, December 03, 2006 6:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo Box not Autocompleting

Thank for the reply Rocky,

The database wasn't recreated in 2003.  I just copied the XP file 
onto the client's computer.

The only thing that needed adjusting was a reference to Microsoft 
Offic XP Web Components (Not sure what that was there for).  I 
removed the reference in both versions of the database - the XP 
version still works fine, the 2003 still doesn't.

I also tried recreating the combo box direct in the 2003 copy but it 
behaved the same way (IE no auto complete).

David

At 4/12/2006, you wrote:
>On the theory that there's some difference in the combo box that you
dropped
>into the original XP mdb and the combo box that you create in A2K3, I
wonder
>what would happen if you deleted the box and re-created it on the A2K3
>system?
>
>Rocky
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
>Sent: Sunday, December 03, 2006 3:05 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Combo Box not Autocompleting
>
>Group,
>
>I have developed a simple database in Access XP (One table, one
>form).  On the form is a combo box that shows all the records on the
>form.  The bound field is a number (long)
>
>When I start entering a number the combo box auto completes it with
>the first match from the list.
>
>When I copy the database to another computer with Access 2003 on it
>(mu client's computer) the combo box does not auto
>complete.  Entering a full number and pressing the enter key returns
>an error message "The Text entered is not an item on the
>list".  However, I can scroll down the actual list and select the item.
>
>Has anyone come across this and have a fix?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>Wellington, New Zealand

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.6/566 - Release Date: 12/3/2006
4:36 PM
 




More information about the AccessD mailing list