[AccessD] Combo Box not Autocompleting

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


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

If you create a new form and create a combo box with a different data source
does it behave the same way?  With the same data source, does it behave the
same way?  IOW, do all combo boxes in this installation of A2K3 fail on the
auto complete?

Is Tools-->Options-->General-->Track Name Autocorrect info turned off?
Don't see why it should matter but that seems to cause a lot of random
problems.

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 9:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo Box not Autocompleting

Nothing unusual.  It is an ID field automatically generated.  Because 
the database is so basic and has a lifespan of about three weeks, the 
data table is in the same file as the form.  The same data was copied 
to the client machine as on my machine.  No records have been added - 
only some fields edited.

David

At 4/12/2006, you wrote:
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

-- 
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