• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

How could create the autofill in a field of a form in Access or VB

Detail:
I try to create a field in a form.
For example:  If I type "a" in the field, it will automatically fill up with related data with start "a", such as "abcdef", "acdfddf", "afdfdfd"
If I type the second character(ex."b"), it will pull out the data which start from "abdfsdfd", "abxxxxx".
And so on.
I'll split the point whatever the input is useful.
Thanks!
Johnny:>
0
johnnywong71
Asked:
johnnywong71
4 Solutions
 
stevbeCommented:
the combobox control provides the exact functionality you are looking for.
0
 
jkorzCommented:
you have to make sure the "Limit to list" property of the combo is set to yes, otherwise it won't do the lookup like that
0
 
johnnywong71Author Commented:
jkorz,
I try to set the "limit to list" to yes.
But it just list all the item.  Could you explain the detail?
Thanks!
Johnny:>
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
jkorzCommented:
what version of access do you have?
0
 
johnnywong71Author Commented:
Let me give a detail example:

default combo box list here:
abcdfhjkh
abcdklkljkj
ajhjhhjh
ayuyuyuy
ajkjkljlj
abhjhkhkh
adjkljkj
hjhjkh
klkl;kkk

If I type "a" in the combo box, it should display only the list
abcdfhjkh
abcdklkljkj
ajhjhhjh
ayuyuyuy
ajkjkljlj
abhjhkhkh
adjkljkj

If I type "ab" in the combo box, it should display only the list
abcdfhjkh
abcdklkljkj
abhjhkhkh

If I type "abc" in the field, it should display only the list
abcdfhjkh
abcdklkljkj

If I type "abcdf" in the field, it should display only the list
abcdfhjkh

Clear?
0
 
johnnywong71Author Commented:
Access 2002 SP-2
0
 
jkorzCommented:
set the AutoExpand property to yes
0
 
jjafferrCommented:
This link gives you the explanation and an example mdb too

http://www.experts-exchange.com/Databases/MS_Access/Q_21180634.html


jaffer
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now