Queries :: Query Truncating Memo Fields

Dec 16, 2014

I have a query that is truncating a memo field to 255 characters. There is no distinct, group by, format, union or concatenate in the query which are the common cause for truncation.The truncated memo field is comments.

Code:
SELECT HearingAuditTbl.CASE_NUMBER,
Null AS appealcaseid,
HearingAuditTbl.HEARING_ALJ,
Null AS DecisionCode,
HearingAuditTbl.DECISION_DT AS ALJ_Date,
HearingAuditViolations.VIOLATION_NO,
HearingAuditViolations.COMMENTS,
"CATEGORY_B" AS CATEGORY,
NOW() AS DATE_ADDED

[code]...

View Replies


ADVERTISEMENT

Exporting Truncating Memo Fields

May 26, 2006

I have a query that is displaying exactly the correct results. However, when I export this to a text/tab delimited file (or even and XLS file) it truncates the memo field to 256 characters in the export file. I am sure it has something to do with this memo field being defined in part by a custom function. Below is the query and the function. The field in question is the "Formatting(First(description_text)) AS prod_Description" column. Any thoughts? Note: I know that if I don't perform the "First" on this memo field, during the group by, the query would truncate this to 256 characters becuase it has to be in the Group By clause. But by using the First function, this field does not need to be included in the group by and there for the query does not truncate it (even though the exporting does).

SELECT ProductList.cin_id AS prod_ID, Formatting([desc]) AS prod_Name, "" AS prod_Flag, "" AS prod_OverrideName, "" AS prod_SortName, Formatting(First(description_text)) AS prod_Description, "" AS prod_Bullets, ProductList.mfr AS prod_Mfr, "" AS prod_itemSort, "" AS prod_ProdGroup, "" AS prod_SubprodSequence, "" AS prod_Layout, "" AS prod_BaseProductID, "" AS prod_ItemSubheadAttr, "" AS prod_Keywords, "" AS prod_URL, "" AS prod_Type
FROM ProductList
GROUP BY ProductList.cin_id, Formatting([desc]), ProductList.mfr
HAVING (((ProductList.cin_id)<>''));

****

Public Function Formatting(Text As String) As String
Dim outString As String
outSring = ""
If Len(Text) > 0 Then
outString = Replace(Text, "<b>", "{")
outString = Replace(outString, "</b>", "}")
outString = Replace(outString, "<i>", "{i")
outString = Replace(outString, "</i>", "}")
outString = Replace(outString, "°", "°")
outString = Replace(outString, "™", "™")
outString = Replace(outString, "©", "©")
outString = Replace(outString, "'", "'")
outString = Replace(outString, "&reg;", "®")
outString = Replace(outString, "<sub>", "{^/")
outString = Replace(outString, "</sub>", "^")
End If
Formatting = outString


End Function

View 6 Replies View Related

Truncating Memo Field

Jan 26, 2006

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?

View 1 Replies View Related

Memo Field Truncating :s

Nov 23, 2005

Hi,

Ok, firstly i have search google and this forum from top to toe and no-1 has an answer that works for me.

I am running a query, now i have completely simplified it. The query is now just picking up a field called recommendations. Recommendations is a memo field with no formating or index on at all. Now, when i run the query as normal it works fine... everything is there. But when i have to group by it. It cuts it off at 255 charactors. The thing is i need to do some sums and counts within the query aswell so it has to be.

I have checked microsoft and there suggestions are not any use.

Any ideas???

View 2 Replies View Related

Memo Truncating On Form

Aug 2, 2006

I searched the forum and realize that there are many posts on this subject, mostly related to exporting the data on reports and such. However, the problem that I am having is within the form. I have two memo fields on my form, named Memo1 and Memo2. Their data source is on a table where both fields there are also memo fields, called Notes and More Notes. I know a memo field can contain up to 65,000 characters, but mine don't seem capable of this and are truncating the data without warning the user, resulting in notations getting "lost". However, when I open the table that the form is bound to and check the Notes field, it DOES contain all the right data PRIOR to truncating. What's happening here? I've reviewed RG's link and have verified that I am not formatting or sorting on these fields, and I've utilized the ZOOM function, and I've checked the names of my fields. The form is built directly from the table, not a query, so I can't understand why this is happening. Starting to get very frustrated. Any suggestions would be welcome. Thanks for your advice.

View 2 Replies View Related

Truncating Of Memo Data Type

Oct 5, 2005

I have a table in my database to track survey responses. Some of these responses can be quite long so I am using the memo data type. I have some queries set up to display these responses but the queries truncate the responses to 255 characters. Is there a way to stop the query from truncating? Thanks in advance.

View 2 Replies View Related

Tables :: Excel Memo Field Truncating

Apr 18, 2013

I have a strange issue where im importing an excel using docmd.transferspreadsheet. I have a memo field which is importing fine and is not being truncated but I have another which is being truncated every time. The destination field is set to memo and the top cell in the excel is over 255 chars yet it still truncates. The other column does not truncate for some reason.

View 2 Replies View Related

Make Table Queries And Concatenated Memo Fields

Jul 13, 2006

I have a Make Table query that includes a new field concatenated from a numeric field and a memo field, with some assorted text elements -
Issue Description:"("&[number]&") "&[Description]

When I run the Make Table, the new field "Issue Description" is created as a text field, NOT as a memo field.

Is there any way to insure that this field is created as a memo field.

Thanks.

Susan

View 1 Replies View Related

General :: Concatenate Two Text Fields Into A Memo Field In Query?

Sep 5, 2014

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

View 3 Replies View Related

Queries :: Split Memo Field In A Query

Feb 26, 2015

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.

My current query looks something like:

ID | Product | Pack Size
1 | item a | 1x1000,1x1050
2 | item b | 1x1000,20x25
3 | item a | 1x1000

(Where the , is a new line)

Whereas my ideal output is:

ID | Product | PackSize
1 | Item a | 1x1000
1 | Item a | 1x1050
2 | Item b | 1x1000
2 | Item b | 20x25
etc.

I think im supposed to use the Split() Function though i dont have a clue wherw to start.

View 11 Replies View Related

Queries :: Memo Append Query Cutting At 255 Characters

Apr 11, 2013

memo fields chopping the content when appending to another table memo field.I have a query that takes in a couple of tables and then appends the content to one larger table.In each of the smaller tables there is a memo filed that when I check it has the entire type content in above 255 without a problem.

When the query runs and appends it to the larger table the content in the memo filed is chopped down.Both tables fields are set to memo I have double checked this.I have seen some comments about unique values in the query properties but these are set to NO as advised but it still does this.

View 4 Replies View Related

Queries :: Memo Field - Render HTML In Query

Aug 27, 2013

I can select memo field (configured as RichText) as rendered html:

select somehtmlfield from sometable

And have rendered html output:

"normal bold"

Or select it as html string

select Cstr(somehtmlfield) from sometable

And get

"<div>normal <b>bold</b></div>

Is there any way to produce rendered html from string?

I would like to:

select SomeConvertingFunc("<div>something <b>bold</b></div>") from sometable

And have it rendered to "something bold".

View 1 Replies View Related

Queries :: Memo Field Appears In Query In Chinese Or Japanese?

May 16, 2013

Table shows memo text fine..

but when i run a query its shows the memo field with text like: 였A and æ„Š` and è¬ï¿½

View 3 Replies View Related

Memo Fields

Aug 15, 2007

Hi All,

This is probably the simplest question to answer but alas I can't find the answer in any of my books!

I have a memo field which when made into the form is for a comments box (therefore has to be a memo box). However, the end user wants to be able to type in the comments and have this is paragraphs but of course the field doesn't want to do it.

I've tried various commands in the properties and also in the formats etc. and now I'm at a loss - can someone please give me some much needed guidance, and I really am sick of looking at this database and would like to get rid of it!

Thanks in advance guys.

Donna :eek:

View 2 Replies View Related

Memo Fields

Jan 18, 2005

How can you use a memo field in a combo box.

How can you edit a memo field used by the combo box once it has been selected in a form.

View 1 Replies View Related

Memo Fields

Nov 2, 2006

I have a memo field in my database, as the data is too long to be a text field. The data in this field has been pasted in from other sources, and somehow it seems to have remembered the original pasted formatting, which was like a newspaper column. So when I include this field on a report, I get a thin column of text, even though the text box on my report is much wider. Is there a way of getting the text from my memo field to wrap to fill the width of my text box, so I get a neat-looking report. Thanks.

View 3 Replies View Related

Hyperlinks In Memo Fields

Dec 9, 2007

I have been asked if is possible to highlight some text in a memo field and make it a hypertext link.

A memo field can be changed to a hyperlink field, this is not what is wanted.

View 1 Replies View Related

Compare Memo Fields

Feb 5, 2008

Can someone tell me if this can be done somehow.

I have a date field, ID field and a memo field (I have to have this memo field).
I want to compare the memo fields by two certain dates and find out what doesn't match and if the ID field is blank. I have been trying with quaries but no luck.

I am not sure what forum this would fall under so I put it in general. feel free to move.

View 7 Replies View Related

Should I Avoid Memo Fields

Jul 18, 2005

I've read on this forum that memo fields can be a spot of bother. I only saw this after I put several memo data types in my tables. I wasn't going to do that much with them; it was intended as a electronic scratch pad of sorts for the user. Where does the trouble arise from with them? Should I just leave them or should I change them to text fields with 255 chars and hope that's good enough?

scratch

View 1 Replies View Related

Memo Fields/boxes

Jan 23, 2006

I have a memo field on a form that I only want 800 characters. (text fields don't seen to work). I'm looking for a piece of code that monitors the typing into a memo field and alerts the user that they are overe quota for that field when 800 characters are passed.

Any ideas are appreciated.

View 3 Replies View Related

Querying Memo Fields

Mar 22, 2007

Hello There,

I wonder if someone can clear up a problem I am having. We have a system under development which is heavily dependent on an existing MS Access database. Some of the queries in the Access version of the application query Memo fields and they work fine within Access.

If I try to use exactly the same query from an ASP/Vbscript web page the query does not return the expected results. I am using ADO and an ODBC DSN connection, all of the other queries seem to work fine.

I have a vague recollection of being told that you can not query Memo fields through an ODBC DSN, or that not all of the Memo field is queried, only the first 255 characters. Can anyone confirm this is true. I have tried searching the web, and some references that I have available, but it seems that there is nothing out there to confirm my suspicions.

Any direction anyone could give me would be hugely appreciated.

Thanks in advance.

View 4 Replies View Related

Auto Expand Memo Fields

Apr 19, 2006

I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.

Any clues would be much appreciated.

Fozi

View 1 Replies View Related

Memo Fields - Order Of Data

Dec 6, 2007

Hello people.

Im just after a bit of advice please??

I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is changed the line of text is added beneath the existing text in the memo field. This means that for users to view the most recent change they have to scroll all the way down to the bottom of the memo field. Is there a "Quick" way of me having the most recent entry first.
I am using the vbnewline command when adding the text. A sample is shown below:

Dim Response As Integer
Dim AnotherItem As Integer
Dim sqlstr As String

Set Myform = Forms![DataDetail]
Producer = Forms![ListOfProducers(Existing Data Item)]![LstProducers].Column(1)

Response = MsgBox("Are you sure you wish to add a Producer?", vbYesNo, "Data Dictionary v1.0")
sqlstr = "INSERT INTO DataProducers ( Data_Id, Producer_Id ) SELECT Data.Data_Id, Producers.Producer_Id FROM Data, Producers WHERE (((Data.Data_Id)=[Forms]![DataDetail]![Data_ID]) AND ((Producers.Producer_Id)=[Forms]![ListOfProducers(Existing Data Item)]![LstProducers]));"
If Response = 6 Then
DoCmd.RunSQL sqlstr
Myform!LstHistory = Myform!LstHistory & vbNewLine & "Changes made on " & Now & ""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "The Producer '" & Producer & "' was added to this data item"""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "-----------------------------------------------------"
MsgBox "Producer has been successfully added.", vbInformation, "Data Dictionary v1.0"


Thanks folks...

View 2 Replies View Related

Unable To Sort Memo Fields?

Mar 16, 2006

A quick question... is it possible to sort a table by a memo field? I have a table and am able to sort by other, non-memo fields, however when I place my cursor in the memo fielld I would like to sort, the sorting option becomes 'greyed-out'. Is there a way around this?

View 7 Replies View Related

Can I Merge 2 Txt Fields To 1 Memo Field

Apr 6, 2006

Hi,

I have an old database for generating service reports which has:
Report No
Date
Customer
Site

In separate fields which is fine

but also

wrk1
wrk2
wrk3
etc.

with a separate field for each printed line on the page
I would like to merge all these into one memo field while retaining the previous data which goes back 15 years (it came from a MSWorks 2.0 DOS db which is the reason for the weird structure I think)

Is there any way to write a macro or code to selectively merge some but not all fields in a table?

I've already copied the db and modified it after clearing all the old data, it works fine but I'd like to have access to the old data in the new format

TIA

Kim

View 3 Replies View Related

Memo Fields Mess Up My Database

Aug 8, 2007

Hello,

when I update a form with a new record, that record will copy to any previous record that I click in the same form.

This only happens when I'm adding records to a table that contains a memo field...

Anything I need to keep in mind about memo fields?

Kind regards,
Hans B.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved