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 >