• Privacy Policy
Halder Consulting, Inc.
  • Home
  • Store
  • Access Blog
  • WordPress Hosting
  • VIP Login
Select Page
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 Queries, MS Access Forms

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...

Recent Posts

  • MS Access Runtime Error (2176): “The setting for this property is too long.”
  • What do those error codes mean?
  • Your Access Application has Crashed! What to do?
  • Gotcha! You thought you deleted a subform record but…
  • Print button on Ribbon prints form instead of report

Recent Comments

  • Willie Clark on Black Leather High Top Sneakers
  • Willie Clark on Navy Leather High-Top Sneakers
  • Willie Clark on Black Well-Worn Sneakers
  • Willie Clark on Grey Well-Worn Sneakers
  • Willie Clark on Black Leather Safety Backpack

Archives

  • March 2022
  • January 2022
  • June 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

Categories

  • MS Access VBA Coding
  • MS Access Tables
  • MS Access Queries
  • MS Access Forms
  • MS Access Features
  • MS Access
  • MS Access Reports

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

FREE TEXT

Energistically benchmark focused growth strategies via superior supply chains. Compellingly reintermediate mission-critical potentialities whereas cross functional scenarios. Phosfluorescently re-engineer distributed processes without standardized supply chains.

RECENT POSTS

  • MS Access Runtime Error (2176): “The setting for this property is too long.”
  • What do those error codes mean?
  • Your Access Application has Crashed! What to do?
  • Gotcha! You thought you deleted a subform record but…
  • Print button on Ribbon prints form instead of report

CATEGORIES

  • MS Access VBA Coding
  • MS Access Tables
  • MS Access Queries
  • MS Access Forms
  • MS Access Features
  • MS Access
  • MS Access Reports

META

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

SEARCH

Welcome to our Access Blog

We have decades of experience with Microsoft Access that we’d love to share with you.

TAG CLOUD

Access Combo Box Crash Reporter Error Codes List Box RowSource VBA

RECENT POST

  • MS Access Runtime Error (2176): “The setting for this property is too long.” March 7, 2022
  • What do those error codes mean? January 31, 2022
  • Your Access Application has Crashed! What to do? January 27, 2022
  • Gotcha! You thought you deleted a subform record but… June 18, 2021
  • Print button on Ribbon prints form instead of report June 4, 2021

ARCHIVES

  • March 2022
  • January 2022
  • June 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

CATEGORIES

  • MS Access VBA Coding
  • MS Access Tables
  • MS Access Queries
  • MS Access Forms
  • MS Access Features
  • MS Access
  • MS Access Reports

LATEST NEWS

  • MS Access Runtime Error (2176): “The setting for this property is too long.” March 7, 2022
  • What do those error codes mean? January 31, 2022
  • Your Access Application has Crashed! What to do? January 27, 2022

TAGS

Access Combo Box Crash Reporter Error Codes List Box RowSource VBA

CATEGORIES

  • MS Access VBA Coding (2)
  • MS Access Tables (2)
  • MS Access Queries (5)
  • MS Access Forms (8)
  • MS Access Features (4)
  • MS Access (8)
  • MS Access Reports (1)

RECENT COMMENTS

  • Willie Clark on Black Leather High Top Sneakers
  • Willie Clark on Navy Leather High-Top Sneakers
  • Willie Clark on Black Well-Worn Sneakers
  • Willie Clark on Grey Well-Worn Sneakers