[AccessD] Memo field on report

Andy Lacey andy at minstersystems.co.uk
Wed Mar 15 02:06:09 CST 2006


Hard to imagine. If you run the recordsource of the report as a straight
select query can you definitely see all of the data in this memo, ie is it
definitely the report that's doing this?

Andy

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Foote, Chris
> Sent: 15 March 2006 07:55
> To: 'Access Developers discussion and problem solving'
> 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