Charlotte Foust
cfoust at infostatsystems.com
Tue May 2 14:58:55 CDT 2006
Are you using a query to view the data? Are you trying to sort on the memo field? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, May 02, 2006 11:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Access 2003 SQL Server 2000 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, May 02, 2006 11:29 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Data from a SQL Server Table Which versions of Access and SQL Server? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, May 02, 2006 9:11 AM To: Access Developers discussion and problem solving Subject: [AccessD] Data from a SQL Server Table I am try to view the data from a SQL table that has one field that Access shows in design mode to be a memo field. Only part of the field displays. I tried exporting it to a text file and viewing it in Wordpad. I see more of the field but not all of it There is a distinct cutoff point (474 characters total on one line). Any suggestions on how to see all the contents of the field. I tried the LEN function on the field for one long record and got a count of 240. I know there are more characters than that. Does LEN not work on memo fields? Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- 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