Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 06-14-2019, 05:28 PM   #16
Newly Registered User
Join Date: May 2018
Location: USA baby
Posts: 1,838
Thanks: 36
Thanked 558 Times in 529 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: only allow correct data input

Find-as-you-type IS a feature of Access (in the sense of being a feature of the combobox which is a feature of Access).
This maybe semantics but FAYT is not considered a built in feature by most people. The feature you are speaking of is autoexpand which is pretty limited.
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 that 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. Read/write Boolean.

FAYT is the ability to reduce the list as you type. This can be very powerful. I have an extremely robust class module that turns any combo into an FAYT. You can see the difference in the demo. The first is a traditional combo, second is an fAYT but searches from the front only. If you type "John" it reduces the list to anything beginning with John. The third is FAYT anywhere in the list so if you type in "John" you return records with John anywhere in the first or last name.

In the example try searching for Johnny Hayes and see the difference. In the third box you can search for hayes as well as johnny.

These lists are 8k and with the FAYT you can find anything in seconds.
Attached Files
File Type: accdb Fayt First Last.accdb (1.87 MB, 11 views)

MajP is offline   Reply With Quote
The Following 2 Users Say Thank You to MajP For This Useful Post:
Gasman (06-15-2019), murray83 (06-17-2019)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Return correct On Change data from cbo to txt box Zydeceltico Forms 3 10-17-2018 05:33 AM
Query result not correct in Access but correct in Excel Onesimus Queries 0 06-19-2011 09:28 PM
Report not showing correct data... accessnewbie89 Reports 6 05-26-2011 03:43 AM
data in tables not correct maxmangion Forms 2 11-29-2004 02:29 AM
problem pulling correct data sullivan Reports 1 12-20-2002 08:42 PM

All times are GMT -8. The time now is 08:36 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World