Update memo field access

Search related threads. Remove From My Forums. Answered by:. Archived Forums. NET Managed Providers. NET managed providers, especially System. SqlClient, System. Odbc and System. Sign in to vote. I've got a Table with a memo field and I made a stored procedure to update this field. And I call this procedure in C. Everything is OK if I call my procedure with a few text to update less than char but if I update with more than char I've got an exception AccessViolationException.

I have create a report based upon the Union Query; however, it will truncate the "Memo" fields to or characters. As a side note, if I create a report based upon a simple query using only one of the linked tables, it does not truncate the field.

Any suggestions on what maybe causing this truncation issue? I have a table that contains a memo that is delimited by line breaks. For each of these breaks i need a new record in the query results that i can then use in a Labelling application.

I think im supposed to use the Split Function though i dont have a clue wherw to start. Running I never ran into this problem before. I have a qry, with showing totals group by. One of the fields is called comments, which is a memo field. I am only seeing partial comments. When I redesign the query and take out the "totals", I see the entire comments. Is there a fix to this? I'm trying to concatenate two text fields into a memo field using an expression in a select query.

My problem is that the text fields together end up more than characters, so I need the resulting field to be a memo instead. I can't change the underlying text fields to memo fields because this is a large database used by others who need those fields to be text. Table shows memo text fine.. Is there a way to populate the value of a memo field with the push of a button. What I am trying to do is have a few default items that can be automatically entered into a memo field.

When I attempt to change the value of the memo field either thru the wizard, macro or by using a simple code like me. I have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries.

When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field.

I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process. Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option. My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field not the plan query.

Would like to double click a plan within the plan query and have that description populated into the form's plan field. I am in the process of changing over a text field to a memo field to generate more space in 5 different databases :eek: Thanks to all the good info on several searches of this forum, I am pretty clear on how to do that.

The question is TIA, Darnys. I am using DoCmd. OutputTo to export a query but this truncates the memo fields, but in the db window,right clicking and choosing to export does not truncate the data. How do I code to output all the data without truncating? That said, you should of course not use a memo field to store text that you know will never be longer then characters.

Don't use a memo field for a first name. This is no different then I shouldn't use a text field to store an integer even though possible , and I shouldn't store dates in a text field either. Taneer I believe the main purpose of this post was to sneak in a link commercial spam to a site.

The link was removed by Rabbit, and I will leave the post as is. People are entitled to their opinions on Memo fields, but I don't really believe this counts as an insight. In general if you keep your frontend seperated from your backend, and avoid doing design changes on a live database the risks of corruption are small. Make sure you have a backup strategy.

Make sure that your local IT department takes regular backups, of the backend file. In 5 years of developing I have twice had the need to retrieve a backup file. One was caused by yours truly running a bad update query wooops and the other was caused by a complete power failure to the network drive.

Post Reply. How can error messages be displayed when using Command Buttons - Access 97? Memo Fields. Word truncates Memo field when using Automation from Access. Visual Basic. Error when using Network share Access File.

Microsoft SQL Server. Error but there are no memo fields. Formatting in memo fields. Memo fields. Memo fields clobbered Access Mobile Development.