Worked like a charm - Thanks agin :) -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 27, 2006 4:22 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters???
Mike- Your query should look like: 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, UCase(TimeEntries.Note) As UpperNote, 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])); Now bind the text box to the UpperNote field from the query. Setting the control source should have worked, too, but existing reports can sometimes get "squirrely" if you try to reference a field that is not also bound to a control somewhere. 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 3:14 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? Hi John, I put the =UCASE([Note]) in the Control Source box for that field on my report, but now it just says #error#. Also tried putting it in my query and it ended up prompting me for "Note" when I tried to open the report. Am I doing something wrong? -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 27, 2006 3:49 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? Well, you can use it in the query or simply use it in the Control Source of the control on the report: =UCase([Note]) 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 2:30 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? OK, where do I insert the UCASE function? -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 27, 2006 2:30 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 1:00 PM To: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Friday, January 27, 2006 12:31 PM To: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 10:40 AM To: ms_access@yahoogroups.com 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 Yahoo! Groups Links 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/
