Mike- Use the UCASE function to convert it and dump the Format spec. It's the Format that is truncating the field.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 1:00 PM To: [email protected] Subject: RE: [ms_access] Report fields limited to 256 characters??? OK, there may be an issue with #2 - I have > entered for format to convert to caps for display purposes. Would that do it? Here is my SQL: SELECT WorkOrders.WOId, WorkOrders.Title, WorkOrders.Description, WorkOrders.Priority, WorkOrders.MachineId, WorkOrders.Created, WorkOrders.Finished, WorkOrders.Status, WorkOrders.EnteredBy, WorkOrders.TotalTime, WorkOrders.datestamp, WorkOrders.timestamp, WorkOrders.Type, WorkOrders.StatusState, TimeEntries.Start, TimeEntries.Stop, TimeEntries.Note, TimeEntries.TechInitials FROM WorkOrders LEFT JOIN TimeEntries ON WorkOrders.WOId = TimeEntries.WOId WHERE (((WorkOrders.Title) Like [Forms]![frm_SelectionList_4_Reports]![SUBCATEGORY]) AND ((WorkOrders.MachineId) Like [Forms]![frm_SelectionList_4_Reports]![MACHINE]) AND ((WorkOrders.Type) Like [Forms]![frm_SelectionList_4_Reports]![Type]) AND ((WorkOrders.StatusState) Like [Forms]![frm_SelectionList_4_Reports]![StatusState])); -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 27, 2006 12:31 PM To: [email protected] Subject: RE: [ms_access] Report fields limited to 256 characters??? Mike- Three reasons why a memo is truncated: 1) You're using it in a Totals query. 2) You have a Format applied to the field. 3) You have asked for Distinct Values (the DISTINCT keyword in SQL) John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 10:40 AM To: [email protected] Subject: [ms_access] Report fields limited to 256 characters??? Hi All, I have a report that looks like it's only displaying the first 256 characters of an entry in a field in my table which is formatted as a Memo field. Is there a way to get the report to display the entire contents of the memo field? I have the report field set to "grow", which it does, but only until is reaches the 256 character point. As always, thanks in advance! ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
