473,750 Members | 2,186 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access autocomplete/autofill text box

10 New Member
I have searched and searched and cannot seem to find an answer that fits my needs. Hopefully you can help.

I have a database that stores names,addresses , etc. I am trying to get it to where I start typing the last name it will 'suggest' names that are already in the table. ex. If the last name is "Johnson", When I start typing "Jo" it will automatically complete as i type.

Any Idea's?

Thank you
Shaft11
Aug 17 '09 #1
6 38627
ajalwaysus
266 Recognized Expert Contributor
I would make the fields, you wish to auto complete, combo boxes where the record source is Last name, First Name...etc. When using a combo box, the results narrow as you type in the box. Try it and let me know if this works for your needs.

-AJ
Aug 17 '09 #2
ADezii
8,834 Recognized Expert Expert
@Shaft11
What ajalwaysus is referring to is the AutoExpand Property of a Combo Box. You can use the AutoExpand property to specify whether Microsoft Access automatically fills the text box portion of a combo box with a value from the combo box list that matches the characters you enter as you type in the combo box. This lets you quickly enter an existing value in a combo box without displaying the list box portion of the combo box. You can also create a Text Box/List Box combination like the one in Windows Help. As you type in the Text portion of the Text Box, the List Box will scroll to whatever has been typed so far. It is a very handy feature but the coding is slightly complex.
Aug 19 '09 #3
Shaft11
10 New Member
Thanks,

It works, but if I add a name that is not in the list I get the 'Not in the list' Error

Other than that it works.

(Sorry it took me so long to reply, I had to buy a new computer due to a STUPID virus)
Oct 25 '09 #4
nico5038
3,080 Recognized Expert Specialist
Might be helpfull to check this page:
http://www.j-walk.com/ss/excel/tips/tip77.htm
when you want to match also sound-like names.

Nic;o)
Oct 25 '09 #5
NeoPa
32,571 Recognized Expert Moderator MVP
@Shaft11
Set the .LimitToList property to No, and call a .Requery after updating the control.
Oct 26 '09 #6
Just do it in Excell, which will allow autocomplete, then import excel into Access.
Oct 14 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2547
by: Dave | last post by:
Hi All, Just getting started with ASP (NOT .NET) and have a question: I have a basic form and I'm trying to add some functionality to it. I want a user to be able to select a product from a list box. After this product is selected have another text box, ProductID update to reflect the product number. In VB I would use an OnChange type thing. Can anyone point me how to do
1
1942
by: Dejan M. | last post by:
CLAN_ID ||| IME(name)||| PREZIME(surname) ||| CASOPIS_ID (journal_id) ||| NAZIV (journal name)||| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| I have the form with these fields. When I enter CLAN_ID automaticly fill up fields IME (name) and PREZIME (surname), and...
1
12257
by: Andrew Chanter | last post by:
I am writing a little routine to perform the following operations from an Acces 97 mdb: 1. create a fixed width text file 2. create/establish a table type link to the text file in Access 3. allow the user to view the text contained in the text file via an Access form. I have been able to achieve this, albeit with one major limitation. That is that the name of the text file needs to be known prior to runtime. In other
4
8192
by: raju5725 | last post by:
have a MS access table and I want to export it to comma delimited text file. How do I do this programmatically using VB.NET or C#? Thanks for any help in advance. Raju
7
2636
prn
by: prn | last post by:
Hi folks, Sometime in the last few days, I must have accidentally done something that changed some kind of switch in Access, but I can't seem to find what it was. This is Access 2003 under XP, BTW. Currently, when I'm editing any kind of textual material within Access, e.g. a SQL statement or something in the Properties for a GUI element, I find that whenever I move the text cursor within that text, it selects (inverts) the text between...
4
5483
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available in versions 3.0 or later of the class. However, also just found out that the new Rich Text property in Access 2007 ALSO does not support full text justification! This seems incredible, that MS would create a brand new application, and not...
16
11133
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in Access 2007 help seems to confirm the above. But that (or at least (b)) seems incredible that it...
8
2755
by: jcoleshill | last post by:
Hello, I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records. In excel, when you want a field to autofill numbering, it's easy. You type in 1,2,3,4 etc. highlight this and drag or double click and magic the rest of the records are filled in for this field with the continued counting. How the $#^%&$%#@ does one do this in Access. I have 2003. Please Help!
16
39476
by: dybalabj | last post by:
I realize this should probably be a simple solution, but I have only been learning PHP and MySQL for a couple weeks. I am attempting to write an invoicing system that uses a MySQL database to store invoices, product pricing, and customer contact info. I would like to automatically fill in the customer's contact info after typing in the first and last name, and the product pricing info after typing in the product name. From my searches I've...
0
8999
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8836
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9394
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9338
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9256
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6803
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4712
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4885
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3322
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.