Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo field truncates to 255 characters

Status
Not open for further replies.

pmo

Technical User
Jan 15, 2001
76
0
0
AU
My memo field in a query is being truncated to only display 255 characters. When this query is used in my report the same thing happens.
The field is set to memo in the table.

Can anyone help please?

Wayne
 
This is a "query" forum. Please post the SQL of your query. I expect you have Group By or DISTINCT or similar in the SQL but I can't tell from my perspective.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Dhookom,
Thanks for responding to my problem.
Since commencing this thread further investigation has shown that the table in which the query was based only included information that was already truncated to 255. This appears to have been created when using an output macro to an excell spreadsheet then importing the information into my current table. Somewhere in the process of going from database to excell I have lost anything beyond 255 characters.

Wayne

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top