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

    • Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    • VS Code, AI, and Me: A Beginner’s Tale of Plugins and Possibilities
    • Access Report Sorcery: Making the Last Page Play by Different Rules
    • Persistent Intelligence (In Progress): Exploring AI Tools for Managing and Modifying Access Codebases
    • Don’t let a “perfect storm” get you down!

    Recent Comments

    1. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    2. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    3. Neil Sargent on Two Form Filtering strategies
    4. RichardRost on Why I think hourly billing is nuts
    5. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group

    Archives

    • July 2025
    • June 2025
    • 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.