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!

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

Query output - Memo field

Status
Not open for further replies.
tallgaluser

tallgaluser

Technical User
May 31, 2005
7
US
I have a table that has a field that is a MEMO field, a query runs off this table but does not output all the contents of the memo field? Why?
 
Sort by date Sort by votes
what are you outputting it to, its probably only outputting the first 255 characters, or thats is what i am assuming.

Are you outputting it to dbase by any chance????
 
Upvote 0 Downvote
If you are using Excel 97 it will only hold 255 chars per cell
 
Upvote 0 Downvote
I am using Excel 2000 and according to the help on line the following is allowed in Excel

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Can anyone tell me why my memo fields in ACCESS are not exporting to Excel. I am way below 32,767.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
450
jedraw
jedraw
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
233
clevercat88
clevercat88
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
539
atadbitslow
atadbitslow
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
241
dhookom
dhookom
BradCustom
  • Locked
  • Question
Convert Access query to SQL query
Replies
5
Views
257
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top