[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