I did try that. There still remains space between line items. Any
options
or is this the only way?
"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
First of all, as you have noticed, the Page Footer (and Page Header)
do
not
grow.
I think you can just make control small and allow it to grow.
--
Duane Hookom
MS Access MVP
After responding below, I moved the note section up to the detail
section.
It does work in that section. I still have a problem though. There is
a
large gap between each line item -- IF I have no notes. If I have
notes,
of
course that space is filled with that information. Can I add something
that
would input the space for notes ONLY IF I have info in the notes
field??
Duane, thank you for your patience and willingness to help me. I am
learning and am most appreciative.
Yes they are set to allow growing.
Truncating at a particular place? I am not certain of what you mean.
They
are not being cut off; i.e. too many characters. They are not
being
copied
and replaced.
Controls are in page footer section.
"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
Are the controls set to allow growing?
Is the number of characters truncating at a particular place?
What section of the report are the controls in?
--
Duane Hookom
MS Access MVP
No. I am entering the information in the order details form.
I created a query - which runs without a problem. Then
created
the
a
Bill
of Lading report. The Packing List Report is created from the
report,
"Invoice". The information displays on the query and the invoice
without
discrepancies.
The 2 reports do not always display the information. ??
"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
Is the information in the field being copied and pasted from
another
source?
--
Duane Hookom
MS Access MVP
I really want a separate report for the Packing List and the
Bill
of
Lading.
The notes from the order details is a field on each of these
reports.
Information entered into that field on the order details
form
SHOULD
be
visible and print on these 2 reports. Only some of the time is
this
happening. I do not see anything different in the way the
information
was
input on the order details form.
If I can get the notes information to "pull forward" to
these
reports,
that
will solve my problem.
It is not the inability to display more than 255 characters.
It
doesn't
display with as few as 10 some of the time, and then does
display
other
times.
Thanks.
"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
Is your base issue the inability to display more than 255
characters
from
the memo field? If so, your subreport can display the memo
field
from
a
record source that includes the field you need for linking to
the
main
report.
--
Duane Hookom
MS Access MVP
Thank you for your response. I will look into the sample
database.
However, I still am questioning "If I create a subreport
linked
to
the
form/subform, will it print every time I print the
form/subform?"
Let
me
explain further. I first enter my information into the
orders/order
details
forms from which I generate an invoice. I am also
wanting
to
generate
a
Bill of Lading and a Packing List from my orders/order
details.
I
have
created reports from this information; however, my
"Notes"
field
does
not
always capture the information that was input. At that
point
it
was
suggested that I use a subreport.
I am listing the SQL below. If you have an opportunity,
will
you
take
a
look at this and see if you can determine why the "Notes"
field
is
not
working all of the time.
SELECT Orders.*, [Order Details].OrderDetailID, [Order
Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order
Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress,
Customers.City,
Customers.StateOrProvince, Customers.PostalCode,
Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber,
Customers.ContactFirstName
&
"
"
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order
Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum,
Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order
Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping
Methods]
RIGHT
JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID =
Orders.EmployeeID)
ON
[Shipping Methods].ShippingMethodID =
Orders.ShippingMethodID)
ON
Customers.CustomerID = Orders.CustomerID) ON
Dealer.DealerID
=
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products
ON
Contracts.ContractID = Products.ContractID) INNER JOIN
[Order
Details]
ON
Products.ProductID = [Order Details].ProductID) ON
Orders.OrderID
=
[Order
Details].OrderID
ORDER BY [Order Details].LineItem;
Thanks in advance.
"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
You stated "If I create a subreport linked to the
form/subform,
will
it
print every time I print the form/subform?"
Forms are generally for screen displaying and editing of
records
stored
in
tables. Reports are for publishing the records to paper (or
screen).
You
might want to review the Northwind sample database to find
out
more
about
reports and subreports as well as orders and order details.
--
Duane Hookom
MS Access MVP
I have a form, Customer Orders, and a subform, Customer
Order
Details.
I
have a report based upon a query using information
from
the
form
and
subform. My problem is that one of the fields does
not
contain
the
information all of the time. Sometimes it does,
sometimes
it
does
not.
I
cannot see why it is doing this.
Suggestion has been to create a subreport and have
master/child
links.
Here is my question. I did not create the first form and
subform
so
I
am
not familiar with this procedure. If I create a
subreport
linked
to
the
form/subform, will it print every time I print the
form/subform?
I
am
not
wanting it to be visible on the form/subform and I do not
want
it
to
print
with it - which is why I created a query/report separate
from
it.
Thanks for your assistance.
JNana
