Error 2176 The Setting For This Property Is Too Long
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error 2176, "The setting for this property is too long." Microsoft Office for Developers > Access for Developers Question 0 Sign in to vote Error 2176, "The setting for this property is too long." This error occurs in Access 2003 when I try to use the AddItem method of a combobox. The item string is only 33 chars long. Is there a size limitation on list items in a combobox or is this a bogus error? Monday, February 14, 2011 6:53 PM Reply | Quote Answers 0 Sign in to vote Thanks all. My problem was in the data. There was punctuation within the data that was throwing it off. CaseyCasey Nutsch FERC Marked as answer by Bruce Song Tuesday, February 22, 2011 6:55 AM Tuesday, February 15, 2011 2:12 PM Reply | Quote All replies 0 Sign in to vote How many entries do you already have in the combo box? The error refers to the total length of the RowSource field, which is the concatenation of all the entries. There is a size limit to it, but I'm afraid I don't remember what it is.Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/djsteele (no e-mails, please!) Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0) Monday, February 14, 2011 8:29 PM Reply | Quote 0 Sign in to vote I tested this code: Private Sub Combo0_GotFoc
this property is too long". If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 16 of 16 Thread: runtime error 2176 "the setting for this property is too long". Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Aug 7th, 2007,02:04 AM #1 oceanboy View Profile View Forum Posts Thread Starter Addicted Member https://social.msdn.microsoft.com/Forums/office/en-US/688ab4d5-fb45-42df-bfe5-b31b09c56657/error-2176-the-setting-for-this-property-is-too-long?forum=accessdev Join Date Jan 2007 Posts 188 runtime error 2176 "the setting for this property is too long". Hello there, I have a recordsource that is claimed to be too long. However, it works fine on my own laptop and another pc (A) but the error message like in the title came out when i run the ACCESS VBA application on the other pc (B). Does anyone know why? OB Reply With Quote Aug http://www.vbforums.com/showthread.php?482722-runtime-error-2176-quot-the-setting-for-this-property-is-too-long-quot 7th, 2007,03:39 AM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. Raiders #1 AKA:Gangsta Yoda™ Posts 60,220 Re: runtime error 2176 "the setting for this property is too long". Maybe a little more information about the issue like what OS' they are running on, what is the content to be saves under each system, etc. VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM. Please post a thread in the appropriate forum. Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 Intel 300 GB SSDs, 2 GBs DDR2 667 MHz RAM, 2 Viewsonic 24" LCDs, Windows 7 SP-1, Office 2010, VS 2013 Reply With Quote Aug 7th, 2007,05:18 AM #3 oceanboy View Profile View Forum Posts Thr
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts http://www.access-programmers.co.uk/forums/showthread.php?t=246966 Go to Page... Thread Tools Rating: Display Modes 05-14-2013, 08:13 PM #1 masoud_sedighy Newly Registered User Join Date: Dec 2011 Posts: 93 Thanks: 43 Thanked 1 Time in 1 Post The setting for this property is too long (frm.Filter = varWhere) I have used below code for search button of my form. I have a text box with the name (txtsearch), when user error 2176 type in the text box and press search button it searches every field in the table for finding contained word, now for example when I want to find (mobile no) and type in the txtsearch "09133933456" it gives error (The setting for this property is too long for frm.Filter = varWhere). But when I type just 3 or 4 character (9133), I have no problem; please help what error 2176 the is the problem and how I can solve. Code: varWhere = "[First Name] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[Last Name] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[ID Number] = '" & Me.txtsearch & "'" varWhere = (varWhere + " or ") & "[MobileNo] LIKE '" & Me.txtsearch & "'" varWhere = (varWhere + " or ") & "[MeliCode] LIKE '" & Me.txtsearch & "'" varWhere = (varWhere + " or ") & "[Mahale_Tavalod] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[Tarikh_Tavalod] LIKE '" & Me.txtsearch & "'" varWhere = (varWhere + " or ") & "[Mahale_Sodor] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[Tahsilat] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[Reshteh_Tahsili] LIKE '" & strWild & Me.txtsearch & strWild & "'" varWhere = (varWhere + " or ") & "[Mahale_Tahsil] LIKE '" & strWild & Me.txtsearch & strWild & "'" v