Code for end of detail section

[Double A]

Is it possible to type in a line of code that will prompt a solid line to be
printed if the detail section is complete? I have a report with the
following fields in the detail section: Info and comments. What prints in
the report for "Info" are a series of bullet points connected to a chosen
category. Some categories has 3 "Info" bullets and some have more. What I
would like to do is after the last bullet for that category has printed, to
have a solid line drawn of a specified length, before the "Comment" is
printed for that same category. Is this possible? Any other way to separate
the comment from the bullets?

Thanks.

 

[Duane Hookom]

Why can't you add a line control at the bottom of the detail section? How
about adding a line at the top of the Report or a Group Footer section?

 

[Double A]

I am not familiar with code other than some basic things. What code would I
use at the end of the detail section? My database is based on customers,
work orders and then specific categories of jobs that can be performed for
each work order. For each category, I have certain text that I needed to
print but I had to break it up into many records because it was longer than
the 255 characters. I tried making it a memo field but that would not work
properly for what I needed. When a category is chosen, on the report it will
print the category (header section) then each record and then comments. I
would like to separate the statements from the comments.

Thanks.

 

[Duane Hookom]

Again, why do you think you need code when there is a line control that can
be placed at the bottom or top of any report section.

You stated "separate the statements from the comments". What is a statement?
You have customers, work orders, categories, and "certain text".

 

[Double A]

I would like the line to separate fields within the section, so not at the
bottom. Sorry I do not know all of the proper language to convey what I am
asking. I'll try again. In the details section the fields are "Info" and
"Comments". These are pulled from a table that was populated using a form.
I would like to separate the data from the "Info" field from the "Comments".
For every "Info" field there is a "Comment" field but not every comment field
will be used for each Info field. So I only want to place a comment after
the last Info and that is what I want to separate.

Any better?

 

[Duane Hookom]

I still don't understand your table structure. Do you have multiple Info and
Comment fields?
What is your exact structure and how do you want this to display in your
report? Can you type something in a reply that looks like your desired report
with some type of identification of the fields and where the line should
appear?

 

[Double A]

Here is what this section would look like in a report.

Walkway (Category)
*Escavate existing walkway from driveway to front stairs. (Info)
*Prepare footing for new walkway.
(Info)
-----------------------------------------------
walkway to be 4' wide x 12' long.
(Comments)

The structure of the table allows you to put a comment for each line of
Info. I would like put my comments only next to the last line of Info to
print, and have a line drawn between them.

Thanks.

 

[Duane Hookom]

Isn't one (Info) related to a (Comment) in a single record in a table? It
looks like you are asking to display all Infos and then a line and then all
Comments. Is this correct?

 

[Double A]

You are correct about the table. Would it be possible to do as you said,
display all the Infos and then a line and then all the Comments? If so, that
would work for my database.

Thanks.

 

[Duane Hookom]

If you want to display a field from record1, record2, record3, and then
display another field from record1, record2, record3, you will need to use
one or more subreports.