Similar to this?
Using the ASCII chart: 65=A; 90=Z

    Dim X As Long, S As String
    
    For X = 65 To 90
        S = S & Chr(X) & " "
    Next
    
    MsgBox Trim(S)

You impress me Kevin. The answers you give are always on point and helpful. Your skills and talent are a asset to this community.

@ Sandra, It's not clear what the purpose of the form is, or what the filterbox is supposed to do. To see something that starts with "z" do you want to force the user to click now many times (consider some languages have tilde letters) with forms that go on and on, my friend? Or do you really want to tromp through the full alphabet for some valid reason?

Why not let the user enter what they want to see?
For example, below I have a modified version of Richard's search form and it has over 10,000 records (because I asked for everything with the "*" in Name 1. In the next image I'll just show records that have "a" in Name1, Name2 and Name3 (is test data).

https://599cd.com/blog/display-article.asp?ID=2252

Thank you Kevin!  Thomas, I have a lot of my forms set up with filters like this. I know what I ask help on sounds weird, but I never claimed to be normal. LOL

Normal ?
That doesn't fit here

@ Sandra, as long as it makes sense to you and the users...
I'm always curios as to why things are done a certain way by others,
then I tuck it into the memory should something similar ever arrive.
Heck, sometimes the answers prompt me go make BIG changes to my designs. :)

Thomas, this is just for my personal use for cleanin up long lists. I use it in my Rolodex, and my Genealogy database to shorten my lists. For instance, there are 556 relatives with the last name Sanders. If I add a new field, or something, I like to work on people with the first name that starts with A, and once I have them updated, I'll work on the ones with B. That way I can keep track of where I'm at, and clicking a button to go from A to B is a faster (yeah, I'm lazy), than typing A* enter, B* enter.

@ Sandra That makes sense for a personal db, thanks for the answer. I'm in the middle of a big cleanup, unfortunately it's not as simple as A to B to C to ... to Z.
As an old boss admonished me, never do on a computer that which is better done on paper. This guy was an ancient, hard-core IBM engineer. As you can see...

Sandra,

The code I posted above will get all upper case letters. To also get lower case you could run another For Next Loop or run a single While Wend Loop.

    Dim X As Long, Y As Long, S As String
    
    X = 65  ' A
    Y = 97  ' a
    
    While X <= 90 And Y <= 122
        S = S & Chr(X) & Chr(Y) & " "
        X = X + 1
        Y = Y + 1
    Wend
    
    S = Trim(S)
    MsgBox S

@ Kevin R. That brings up an interesting question. When doing a SQL for a recordset inside VBA or in a query, is there a way to specify case sensitive that's not module or db wide?

Thank you Kevin! I really appreciate your help.