Error 2176 Access

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about ms access runtime error 2176 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges run time error 2176 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each bitcasa error 2176 other. Join them; it only takes a minute: Sign up VBA Access: Run-time Error '2176'-The setting for this property is too long up vote 2 down vote favorite There is an access database table called DemoImageT with a field access the setting for this property is too long called Image to store images (using OLE Objects). It has another field called ID which is a text field. It has values 1,2,3..etc. I have an Image holder called ImageBox1 in an Access form. When a button is clicked I want to display the image stored in the table in the image holder on the form. I executed a query and stored the results in a recordset. Then I set the picture property to the retrieved image. My code was: Dim myConnection1 As ADODB.Connection Dim myRecordSet1 As New ADODB.Recordset Set myConnection1 = CurrentProject.AccessConnection Set myRecordSet1.ActiveConnection = myConnection1 myRecordSet1.Open "SELECT * FROM DemoImageT WHERE ID = '1'" If IsNull(myRecordSet1.Fields(1)) = False Then MsgBox ("Image present") ImageBox1.Visible = True ImageBox1.Picture = myRecordSet1.Fields(1) Else MsgBox ("No image") End If I get the message box Image present. But then I get: run time error 2176- The setting for this property is too long. The error occurs in the line: Me.ImageBox1.Picture=myRecordSet1.Fields(1) Is there something wrong with the code? Is there any other way to retrieve images stored in an Access database using VBA and display it on a form? If the above method is correct, what might be wrong? image vba ms-access share|improve this question edited Mar 14 '14 at 12:45 Linger 12.4k133570 asked Mar 14 '14 at 12:35 Prithvi Raj 2316 what does myRecordSet1.Fields(1) actually return? –user2140173 Mar 14 '14 at 12:38 @mehow: An image(OLE Object). Can a recordset not hold an image? –Prithvi Raj Mar 14 '14 at 12:40 1 what do you get is you Debug.print myRecordSet1.Fields(1)? Do you get a binary for the image? AFAIK, access can store Ole Objects. –user2140173 Mar 14 '14 at 12:41 Possibly THIS has an answer –user2140173 Mar 14 '14 at 12:47 +1 for presentation –Smandoli Mar 14 '14 at 13:03 | show 4 more comme

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 3 of 3 Thread: Runtime error 2176 The setting for this property is too long Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-19-03,19:02 #1 Sia View Profile View Forum Posts Registered User Join Date Dec 2002 Location Washington D.C. Posts 164 Unanswered: Runtime error 2176 The setting for this property is too long Hi, http://stackoverflow.com/questions/22405162/vba-access-run-time-error-2176-the-setting-for-this-property-is-too-long I have a form which has a couple of text boxes. The text boxes are bound to a SQL Server table with Varchar (8000) Data type. Due to the fact that there is a long text in each control box, I have created a Zoom functionality. I have crated a new Text box control named ZText (unbound) which is invisible until the zoom button is clicked. After the user clicks the Zoom button, the Ztext control box becomes visible on the form http://www.dbforums.com/showthread.php?789670-Runtime-error-2176-The-setting-for-this-property-is-too-long which is larger than the original one. Then I put the text from the original control box (IssueTxt) to the Zoom one. It works so far and the user can view the contect in a larger box. But the problem is when I want to save the edits (if any). When I want to set the orginal text box to the new, if the text is long I get the following error: Runtime error 2176,The setting for this property is too long Here is the code I use for save: Private Sub SEdit_Click() DoCmd.RunCommand acCmdSaveRecord Dim text As String Me!Ztext.SetFocus text = Me!Ztext.Text Me!IssueTxt.SetFocus Me!IssueTxt.Text = text Me!Ztext.Visible = False Me!SEdit.Visible = False Me!close.Visible = False Me!YBox.Visible = False End Sub any ideas what the problem could be? The intellect is better than desire, for the intellect makes you a king over your destiny, and desire makes you a slave of your destiny. Reply With Quote 11-19-04,17:51 #2 FastAl View Profile View Forum Posts Registered User Join Date Nov 2004 Posts 1 Sia, Late relpy, yes, but here's the solution: use the .Value property instead of the .Text property. Pitfall for VB programmers!!! _______________________ Follow Christ. Cheat Death. Reply With Quote 11-20-04,06:08 #3 izyrider View Profile View Forum Posts Cavalier King Charles Join Date Dec 2002 Location Préverenges, Switzerland Posts 3,740 Shift-F2 is not good enough? izy currently using SS 2008R2 Reply With Quote Quick Navigation Microsoft Access Top Site Areas Settings Private Messages Subscription

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. http://www.vbforums.com/showthread.php?482722-runtime-error-2176-quot-the-setting-for-this-property-is-too-long-quot To start viewing messages, select the forum that you want to visit from the selection http://www.access-programmers.co.uk/forums/showthread.php?t=98847 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 Join Date Jan 2007 error 2176 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 7th, 2007,03:39 AM #2 RobDog888 time error 2176 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 Thread Starter Addicted Member Join Date Jan 2007 Posts 188 Re: runtime

Register FAQ Community Top 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 Go to Page... Thread Tools Rate Thread Display Modes 12-13-2005, 10:23 PM #1 haresh7263 Guest Posts: n/a Form.Recordsource :: Runtime Error 2176 " The Setting for this property is too long" Hello Experts, I am new at VBA and I was trying modify the Query dynamically using VBA. When my code is executed I am getting Runtime Error 2176 " The Setting for this property is too long"; at the line where I am assigning the STRING (SQL) to the Form.Recordsource. Me.Parent.Form("subform_qry_issues_and_actions").F orm.RecordSource = strFilterSQLz Anyhelp would be highly appreciated. The Code goes as follows: Private Sub btn_RunQuery_Click() Dim strFilterSQLz As String Dim strFilterSQL2 As String 'Dim temp1, temp2, temp3, temp4, Date1, Date2, Date3, Date4 'Variable to hold filtered SQL string 'Dim strFilterSQLz As String Dim str 'Set default record source of form strFilterSQLz = "SELECT ACTIONS_T.ActionID, ACTIONS_T.AID, ACTIONS_T.IssueID, ACTIONS_T.ActionPointDescription, ACTIONS_T.TrafficLightColour,ACTIONS_T.ActionPoint PrimaryResponsibility, ACTIONS_T.ActionPointOwner, ACTIONS_T.DateAssignedToAP_Owner, ACTIONS_T.ProgressToDate,ACTIONS_T.OriginalTargetC ompletionDate, ACTIONS_T.ActualCompletionDate, ACTIONS_T.ActionStatus, ACTIONS_T.ExternalLegalCost,ACTIONS_T.HoursEffortS pent, ACTIONS_T.ALT, ACTIONS_T.ELT, ACTIONS_T.IT, ACTIONS_T.CustServ, ACTIONS_T.MaRS, ACTIONS_T.MMB, ACTIONS_T.[C&I]," & _ " ACTIONS_T.[W'sale], ACTIONS_T.Regulatory, ACTIONS_T.Legal, ACTIONS_T.ExtAff, ACTIONS_T.Finance, ACTIONS_T.Agility, ACTIONS_T.Alinta,ACTIONS_T.Audit, ACTIONS_T.[P&C], ACTIONS_T.BillOps, ACTIONS_T.CustTransf, ACTIONS_T.NetwOps, ACTIONS_T.SuppServ, ACTIONS_T.BusSyst,ACTIONS_T.BSCProj, ACTIONS_T.TrafficLightColour, VISUAL_STATUS_T.TrafficLightColour, ACTION_TEAMS_T.ActionTeam, ACTIONS_T.ActionPointPrimaryResponsibility, ACTION_OWNER_T.ActionOwner, ACTIONS_T.ActionPointOwner, ACTIONS_T.ActionStatus, issues_and_actions_subquery.IssueName," & _ " issues_and_actions_subquery.IssueDescription, issues_and_actions_subquery.IssueID, issues_and_actions_subquery.TeamName, issues_and_actions_subquery.ItemStatus, issues_and_actions_subquery.Priority, issues_and_action