Access JumpStart
  • Home
  • Blog
  • Sample Page
  • MS Access
  • MS Access Features
  • MS Access Forms
  • MS Access Queries
  • MS Access Reports
  • MS Access Tables
  • MS Access VBA Coding
  • Uncategorized
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 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...

Recent Posts

  • VBA Compiler Constants are handy… beware of the details
  • Using the Access Web Browser Control
  • acCmdDeleteRecord – unintended problems
  • MS Access Runtime Error (2176): “The setting for this property is too long.”
  • What do those error codes mean?

Recent Comments

No comments to show.

Archives

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

Categories

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