can search for records that begin with each letter?
Your question reminded me of a Form I know about from an early version of the Microsoft Northwind Sample database. The Northwind database is a database provided by Microsoft to demonstrate the functionality available in Microsoft Access. It's for demonstration purposes only, and you shouldn't use it for doing accounts, not unless you change some things as described on my website here:-
Northwind Problem and Solution
In the YouTube Video I show the Form, and I point out a feature that I think might be useful to you and that is an Option Group, but not a normal Option Group, it's an option group containing letters (Toggle Buttons). A very clever idea. as many of the features demonstrated in the Northwind Sample database are. They are well worth exploring to see what you can do with Microsoft Access and I recommend everyone should download your own copy to peruse.
Northwind Customer Phone List - Nifty Access
I also provide a list of download links to the various Microsoft Northwind Sample files HERE:-
https://www.niftyaccess.com/northwind-downloads/
The Northwind links page is getting a bit dated, I'm not 100% sure if all the links work! Feedback would be useful!
If you find my video useful then
I would be grateful if you would sign up to my YouTube channel. I'm hoping to get to 1000 followers shortly, which opens up a tranche of upgrades which I'm really looking forward to having!
Uncle Gizmo's YouTube channel
Bare Link:-
I have been answering questions about MS Access on various forms for 15 years! This experience has given me a unique insight to the problems people have when...
www.youtube.com
If you
sign up you will get notified every time I upload a new video demonstrating a solution to a problem in MS Access...