Mar 21 2007, 09:26 AM
I have a recurring problem I've been unable to solve. I have a "Comments" section in a table. The data type is MEMO. When I feed the data (bound to a temp table) to the report, the comments Don't Appear. Can anyone tell me why this is happening and how to fix this. All table data type properties are set to Memo. The comments are the most important part of this particular report. Looking for a fix ASAP please!
Mar 21 2007, 09:44 AM
Shown below is the value I'm getting in the comments section. that's it. There should be two paragraphs of text there. What is this?
Mar 21 2007, 09:50 AM
Are you importing the data from somewhere into the table and the field? Or are you typing in the data directly to the field?
Is that view a report view or is that what it shows in the actual field and cell in the Table?
Edited by: RAZMaddaz on Wed Mar 21 10:55:07 EDT 2007.
Mar 21 2007, 09:59 AM
I am creating the temp table on the fly using SQL and capturing data elements from several perm tables. Everything in this procedure works great, except this. The value I get is what actually shows up in the temp table, thus the comments are not making the transition to the temp table even prior to hitting the report. So I guess we can rule out for now report properties.
Mar 21 2007, 10:04 AM
So the data you are getting is from several "perm tables." What field(s) of which "perm table" are you trying to get this comments data from? Any what "data type" is that field?
Mar 21 2007, 10:24 AM
The base data types and all intermediate data types for this field are "memo". Does it matter if a crosstab query is involved...because it is.
Mar 21 2007, 10:39 AM
Sometimes crosstab queries can be a problem, but I don't know whether it is here...yet. Two suggestions: 1. Create a basic Select Query where the source is the crosstab query you created. Then base the report off the new query. 2. Sometimes when you create a crosstab query, in order for another query or even a report to see the new columns, you need to in the Properties area of the crosstab query add the "Column Headings" names. Enter the names that you want to see in the query and seperate each one by a comma.
By the way, you might want to attach your database/file, so one can take a look at it. Delete all private data first though!!!
Edited by: RAZMaddaz on Wed Mar 21 11:45:24 EDT 2007.
Mar 21 2007, 12:52 PM
Any luck yet?
Mar 22 2007, 08:40 AM
My Report is bound direct to a TempTable. It's the query process that screwing with the memo field properties. I now have the text displaying but it is now truncating at 255 characters. The text in the TempTable is fine. Somehow, the report recordsource (tempTable) loses the comments "memo" data type when displaying the field in the report footer. Any additional ideas? Anyone?
Mar 22 2007, 02:14 PM
What is the controlsource of the control that holds the memo field from the table? You may be using one of several string functions on the memo that can cause it to get truncated to 255 characters.
Mar 22 2007, 06:57 PM
I suspect that little square box represents some type of non-printable ASCII control character that could be causing your data to be truncated. I have seen some code around this forum somewhere that removes all non-printable characters from a string.
Mar 22 2007, 08:44 PM
Crosstabs usually aggregate the data and when you aggregate a memo field it will truncate to 255 characters.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here