Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 14th, 2006, 10:52 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default Truncated Memo field on Report

Hi Everyone.

I have a report which is pulling data from a query. The memo field is complete in the query but when displayed in the report it is truncated. Anyone know how or why this is happening?

Thanks

Mike

Mike
EchoVue.com
__________________
Mike
EchoVue.com
Reply With Quote
  #2 (permalink)  
Old August 15th, 2006, 01:06 AM
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

are you sorting on the memo field?

If yes, this will cause the truncation to 255 characters.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
Reply With Quote
  #3 (permalink)  
Old August 15th, 2006, 01:19 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Hi Boyd,

Not from what I can see... I also checked to ensure I wasn;t grouping on it and that seems clear as well.

I have created another report with the same query and it works just fine in there, so my next step is to copy the nice formatting over the new report and see if that makes a difference.

Access usually plays nice with my, but has been a little sneaky the last few days!!

Thanks again,

Mike

Mike
EchoVue.com
Reply With Quote
  #4 (permalink)  
Old August 15th, 2006, 01:38 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Hi Boyd,

This is report is interesting in that I set the RecordSource at RunTime. I discovered that as part of the Open Sub, I was using a DISTINCT on the SQL statement. Removed that after eliminating the need for it in the underlying table, it works like a charm.

Thanks for your help.

Mike

Mike
EchoVue.com
Reply With Quote
  #5 (permalink)  
Old August 15th, 2006, 07:34 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

FYI: SQL Server 2005 eliminates the 255 character limitation of SQL Server 2000 blob / memo fields.

mmcdonal
Reply With Quote
  #6 (permalink)  
Old August 16th, 2006, 09:52 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

This is a bug that Microsoft has been intending to fix for a long time but has not gotten around to it. It's especially true when using the SendObject method to e-mail reports.

Supposedly, they fixed it

http://support.microsoft.com/kb/326605/en-us

However, I'm using Access XP and it STILL happens.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memo Field Brendan Bartley Access 11 December 13th, 2007 04:28 PM
Truncated field when copying Tachyophan Access VBA 3 November 16th, 2006 08:23 AM
Memo field not displaying meichmann SQL Server ASP 3 August 31st, 2006 12:36 PM
MEMO FIELD! With VB6 rolandatem Pro VB Databases 2 January 28th, 2005 10:49 PM
Pagefault from memo field dave_pollak Access VBA 0 November 24th, 2004 10:25 AM



All times are GMT -4. The time now is 01:10 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.