What are you looking for, a table list of every banks routing numbers? Or do you have a list already and want to stop mistakes?

Also, there are websites that will give you all the valid routing numbers of banks in the USA.

https://bank-code.net/routing-numbers

Hi Eduardo

I think this site has all 28000 but there may be a fee involved. https://www.aba.com/about-us/routing-number#:~:text=In%20addition%20to%20listings%20of,Number%20information%20for%20research%20purposes.

John

I just checked out the site that Sami gave, and they have a search form that then uses QueryString variables to look up the bank by routing number. For example:

https://bank-code.net/routing-numbers?bank=&routingcode=063104668&state=&city=&submitBtn=search

I typed in my bank's routing number and it came back with a page listing Regions Bank. However, if I changed it by a digit, it just went back to the main page with a "Warning! No result found for your search."

You could use API calls in Access to look up this information when your users enter a number.

See: Web API

This might actually make a pretty cool video, so if you can't figure it out, let me know. I'll add it to the TechHelp list.

Thank you all for your Feedback

Sami. Great feedback. https://bank-code.net/routing-numbers
Richard:

Using https://bank-code.net/routing-numbers?bank=&routingcode=063104668&state=&city=&submitBtn=search

1 I do not know how to get the API (if it exists for this website)

2. One way to do this is to get the source text in the page returned by the search and use you Account Balances Procedure.
"Public Function SwitchToAppAndCopyToClipboard(WindowTitle As String) As Boolean" to
a. check for STRING "Warning" If it does not exist or
b. Check for STRING  "Routing Number"
Then Clean it and return the Bank Name.

3. Using the knowledge in Edge Browser Lesson 8 to retrieve the text

Which way do you suggest to go?

in the mean time I am using a Double Click event in my Routing Field in the Form:
'------------------------------------------------------------------------------------------------------------------
Private Sub Routing_DblClick(Cancel As Integer)

    Dim CurrentBankLink As String
    CurrentBankLink = "https://bank-code.net/routing-numbers?routingcode=" & Routing & "&submitBtn=search"
    'Open Webpage
    Application.FollowHyperlink CurrentBankLink

End Sub
'-----------------------------------------------------------------------------------------------------------------

This is a "Good Enough" solution until I incorporate a way to read the Text from the Web page directly into my form.