Access JumpStart
  • Homepage
  • Blog
Select Page
  • Homepage
  • Blog
MS Access Runtime Error (2176): “The setting for this property is too long.”

MS Access Runtime Error (2176): “The setting for this property is too long.”

by Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries

This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...

Get a Daily Email

An email loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.

    Recent Posts

    • (no title)
    • Daily writing ideas
    • Types of Microsoft Access Installers and Launchers I’ve built
    • Using combo boxes to select an entry and update form fields
    • Hiding duplicate records using running totals over a group

    Recent Comments

    1. | Access JumpStart on Super Simple Code Kata
    2. Mike Wolfe on Running parallel SQL server databases for testing
    3. Custom Tags For Custom tags for form controls – reimagined code | Access JumpStart on Custom tags for form controls – the case to use them for
    4. cristianbuse on VBA function to de-dupe spaces from a string
    5. Jonathan Halder on Some vanilla VBA error handling scenarios

    Archives

    • May 2025
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • January 2024
    • December 2023
    • November 2023
    • December 2022
    • March 2022
    • January 2022
    • June 2021
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020

    Categories

    • Blogging
    • MS Access
    • MS Access Features
    • MS Access Forms
    • MS Access Queries
    • MS Access Reports
    • MS Access Tables
    • MS Access VBA Coding
    • TDD
    • Uncategorized
    • Versioning
    Copyright © Halder Consulting Inc.