Re: [AccessDevelopers] Reports: Displaying time and how to make text flow from one page to another

[A.D.Tejpal]

Debbie,       As apparent from your post, you are trying to implement the following.     (a) Display time value in Short Time format, on a new line in a concatenated string.     (b) Ensure proper space utilization, even with long memo fields.       For illustration, let there be two fields in report's record source, named CaseName (text type) and CaseTime (date/time type) and corresponding bound controls in the detail section. These bound controls can be kept hidden. Insert an unbound text box named Txt_A in the detail section.       Sample code given below, placed in format event of detail section will display the desired information in Txt_A. If any value exists in CaseTime field, it will appear on a new line in Txt_A, as part of overall concatenated string.       For handling memo fields, please ensure that KeepTogether property of detail section is set to No. If necessary, similar action should be taken for group headers.       Note - Whenever memo fields are involved, it is highly desirable to set KeepTogether property of detail section to No. Otherwise, the report may hang up indefinitely, if any memo field happens to span more than one page.   Best wishes, A.D.Tejpal   ==================================== Private Sub Detail_Format(Cancel As Integer, _                                             FormatCount As Integer)     Txt_A = CaseName & IIf(IsNull(CaseTime), "", _                 vbCrLf & Format(CaseTime, "Short Time")) End Sub ====================================   ----- Original Message ----- From: Jones, Glenn P MSG (Ret) FL-ARNG To: AccessDevelopers@yahoogroups.com Sent: Tuesday, November 08, 2005 23:52 Subject: RE: [AccessDevelopers] Reports: Displaying time and how to make text flow from one page to another Debbie, To create a parent-child relationship you need to have primary and foreign key relationships.  When you try to relate to a null items you can come up with all kinds of strange things. I'm sure AD could provide you a more precise answer that I. Glenn P. Jones -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bassfolks Sent: Monday, 07 November, 2005 13:25 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Reports: Displaying time and how to make text flow from one page to another We have a form database used to summarize records in different case situations.  The parent table contains date, provider, etc.  The child table contains descriptive information relating to the provider on a particular date.  One of the fields in the child table is time of procedure and the format is set to display in short time.  In the table and form it displays properly.  In the subreport, the field is concantenated to display the category, if there is one, create a new line and display the time, if there is one.  Not every record contains information regarding category and time.  The subreport sorts by time.  We are unable to get the time to display as short time.  Is there a way to do that? In addition, the description of the procedure is a memo field and can be quite lengthy at times, making the report appear clunky if the record before the lengthy one is short, causing a record with a few lines to appear on a page by itself in order to accommodate the record with the lengthy description on the subsequent page.  Is there a way to force the records to flow evenly?  In other words, to fill each page margin to margin? Thanks! Debbie Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.