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 > >