[AccessD] Memo field on report

John Eget joeget at vgernet.net
Wed Mar 15 02:44:59 CST 2006


my final query has the total option enabled and that is truncating the memo 
field.

so now i know


----- Original Message ----- 
From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 15, 2006 2:55 AM
Subject: Re: [AccessD] Memo field on report


> That's me out of ideas then ;-)
>
> I assume that you've checked that the temporary tables contain the Remarks
> contents and that this is not being truncated somewhere other than the
> report?
>
> Andy? Any other ideas?
>
> Chris F
>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Eget
>> Sent: Wednesday, March 15, 2006 7:48 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Memo field on report
>>
>>
>> Absolutely, the detail section is also set to grow.
>> ----- Original Message ----- 
>> From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com>
>> To: "'Access Developers discussion and problem solving'"
>> <accessd at databaseadvisors.com>
>> Sent: Wednesday, March 15, 2006 2:44 AM
>> Subject: Re: [AccessD] Memo field on report
>>
>>
>> > Ok John!
>> >
>> > Is the "Can Grow" parameter for the section that contains
>> the control set
>> > to
>> > "Yes"?
>> >
>> > Regards
>> > Chris F
>> >
>> >> -----Original Message-----
>> >> From: accessd-bounces at databaseadvisors.com
>> >> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Eget
>> >> Sent: Wednesday, March 15, 2006 7:35 AM
>> >> To: Access Developers discussion and problem solving
>> >> Subject: Re: [AccessD] Memo field on report
>> >>
>> >>
>> >> Good Morning to you also.
>> >>
>> >> Absolutely! That was one of the very first things that I checked
>> >>
>> >> ----- Original Message ----- 
>> >> From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com>
>> >> To: "'Access Developers discussion and problem solving'"
>> >> <accessd at databaseadvisors.com>
>> >> Sent: Wednesday, March 15, 2006 2:26 AM
>> >> Subject: Re: [AccessD] Memo field on report
>> >>
>> >>
>> >> > Good morning John!
>> >> >
>> >> > Have you checked that the "Can Grow" parameter for your
>> >> relevant control
>> >> > on
>> >> > the report is set to "Yes"?
>> >> >
>> >> > Regards
>> >> > Chris F
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: accessd-bounces at databaseadvisors.com
>> >> >> [mailto:accessd-bounces at databaseadvisors.com]On Behalf
>> Of John Eget
>> >> >> Sent: Wednesday, March 15, 2006 7:15 AM
>> >> >> To: AccessD at databaseadvisors.com
>> >> >> Subject: [AccessD] Memo field on report
>> >> >>
>> >> >>
>> >> >> All
>> >> >> I have several make table queries to make a selection of data
>> >> >> for a report.  One of the fields (Remarks) is a Memo field.
>> >> >> When displayed on the report, the memo field is limited in
>> >> >> size and does not display all of the text in the memo field.
>> >> >> Does anyone have an idea?  It is almost as if the memo field
>> >> >> is being displayed as a text field
>> >> >> John
>> > -- 
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > http://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list