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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why is the text in my memo boxes being truncated in my reports?
I'm working on a database for work that involves creating multiple unique
reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was under the impression that memo boxes could contain up to 64,000 characters, yet when I run my reports the text inside the boxes is truncated to 255 characters. Any suggestions? |
#2
|
|||
|
|||
Why is the text in my memo boxes being truncated in my reports?
If your query uses DISTINCT or it is a TOTALS query or a UNION query your
memo fields will be truncated. If you apply any formatting to the memo-field controls, the data will be truncated. "veggiehead23" veggiehead23 @discussions.microsoft.com wrote in message ... I'm working on a database for work that involves creating multiple unique reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was under the impression that memo boxes could contain up to 64,000 characters, yet when I run my reports the text inside the boxes is truncated to 255 characters. Any suggestions? |
#3
|
|||
|
|||
Why is the text in my memo boxes being truncated in my reports
Thanks John! I feel pretty dumb that I spent time racking my brain over this
issue when it was a simple as changing the type of query. But oh well, we can't all be rocket scientist all of the time! Thanks again. "John Spencer" wrote: If your query uses DISTINCT or it is a TOTALS query or a UNION query your memo fields will be truncated. If you apply any formatting to the memo-field controls, the data will be truncated. "veggiehead23" veggiehead23 @discussions.microsoft.com wrote in message ... I'm working on a database for work that involves creating multiple unique reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was under the impression that memo boxes could contain up to 64,000 characters, yet when I run my reports the text inside the boxes is truncated to 255 characters. Any suggestions? |
#4
|
|||
|
|||
Why is the text in my memo boxes being truncated in my reports
Hi John,
I have the same problem. What's a DISTINCT, TOTALS or UNION query? How do I know whether the query I selected is any of the above and how do i make sure it is none of these? Thanks so much. -- Bluet00th "veggiehead23" wrote: Thanks John! I feel pretty dumb that I spent time racking my brain over this issue when it was a simple as changing the type of query. But oh well, we can't all be rocket scientist all of the time! Thanks again. "John Spencer" wrote: If your query uses DISTINCT or it is a TOTALS query or a UNION query your memo fields will be truncated. If you apply any formatting to the memo-field controls, the data will be truncated. "veggiehead23" veggiehead23 @discussions.microsoft.com wrote in message ... I'm working on a database for work that involves creating multiple unique reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was under the impression that memo boxes could contain up to 64,000 characters, yet when I run my reports the text inside the boxes is truncated to 255 characters. Any suggestions? |
#5
|
|||
|
|||
Why is the text in my memo boxes being truncated in my reports
If you can open your query in the query grid, it is not a UNION query. That
can only be created in the SQL text view. The easiest way to identify the query is to change the view to SQL and look for the following: UNION or UNION ALL between two (or more) query statements "SELECT Distinct " at the beginning of the query. SUM, GROUP BY, COUNT, Average or other aggregate functions within the Query. In the query grid - if you have a Totals Line in the grid then you have a "Totals" query or an aggregate query. In the query grid properties for the query, if Unique Values = "Yes" then you have a Distinct query. "Bluet00th" wrote in message ... Hi John, I have the same problem. What's a DISTINCT, TOTALS or UNION query? How do I know whether the query I selected is any of the above and how do i make sure it is none of these? Thanks so much. -- Bluet00th "veggiehead23" wrote: Thanks John! I feel pretty dumb that I spent time racking my brain over this issue when it was a simple as changing the type of query. But oh well, we can't all be rocket scientist all of the time! Thanks again. "John Spencer" wrote: If your query uses DISTINCT or it is a TOTALS query or a UNION query your memo fields will be truncated. If you apply any formatting to the memo-field controls, the data will be truncated. "veggiehead23" veggiehead23 @discussions.microsoft.com wrote in message ... I'm working on a database for work that involves creating multiple unique reports for deep-sea submersible dives. A portion of the report includes three memo boxes that contain information on the biological and physical environment of the area encountered by the sub. I was under the impression that memo boxes could contain up to 64,000 characters, yet when I run my reports the text inside the boxes is truncated to 255 characters. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filling in an array of text boxes based on a query? | tjandt | Running & Setting Up Queries | 3 | August 10th, 2005 08:24 PM |
ComboBox populates text boxes, how to edit text now? | DrewTheFather | Using Forms | 2 | August 9th, 2005 08:37 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
Problems with anchored text boxes | nickblaze | Page Layout | 4 | November 16th, 2004 04:18 PM |