Subreport vs queryquestion

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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

Ok, I don't understand what you mean by spaces or gaps between line items.
Access reports of sections and controls and records from the record source.
"Lines" are either the result of Line controls or the Line method of the
report. "spaces" can be either vertical space or horizontal space between
controls.

Can you provide more details on what you are seeing and would like to
correct?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

Example:

1 Widget $0.94 $0.94

10 Whistles $0.80 $8.00

Total $8.94


Between the quantity of 1 widget and the second line item, 10 whistles, is
extra spacing. I would like for it to be as below, if no notes.

1 Widget $0.94 $0.94
10 Whistles $0.80 $8.00
Total $8.94

If notes:

1 Widget $0.94 $0.94
Special ordered from Alaska
10 Whistles $0.80 $8.00
Total $8.94

Hope this explains.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Ok, I don't understand what you mean by spaces or gaps between line items.
Access reports of sections and controls and records from the record
source.
"Lines" are either the result of Line controls or the Line method of the
report. "spaces" can be either vertical space or horizontal space between
controls.

Can you provide more details on what you are seeing and would like to
correct?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

Set the Notes text box height to .001" and allow it to grow. Make sure the
detail section is shortened to only accomodate the size of the controls.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Example:

1 Widget $0.94 $0.94

10 Whistles $0.80 $8.00

Total $8.94


Between the quantity of 1 widget and the second line item, 10 whistles, is
extra spacing. I would like for it to be as below, if no notes.

1 Widget $0.94 $0.94
10 Whistles $0.80 $8.00
Total $8.94

If notes:

1 Widget $0.94 $0.94
Special ordered from Alaska
10 Whistles $0.80 $8.00
Total $8.94

Hope this explains.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Ok, I don't understand what you mean by spaces or gaps between line
items.
Access reports of sections and controls and records from the record
source.
"Lines" are either the result of Line controls or the Line method of the
report. "spaces" can be either vertical space or horizontal space between
controls.

Can you provide more details on what you are seeing and would like to
correct?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

Thank you!
"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Set the Notes text box height to .001" and allow it to grow. Make sure the
detail section is shortened to only accomodate the size of the controls.

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
Example:

1 Widget $0.94 $0.94

10 Whistles $0.80 $8.00

Total $8.94


Between the quantity of 1 widget and the second line item, 10 whistles,
is
extra spacing. I would like for it to be as below, if no notes.

1 Widget $0.94 $0.94
10 Whistles $0.80 $8.00
Total $8.94

If notes:

1 Widget $0.94 $0.94
Special ordered from Alaska
10 Whistles $0.80 $8.00
Total $8.94

Hope this explains.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Ok, I don't understand what you mean by spaces or gaps between line
items.
Access reports of sections and controls and records from the record
source.
"Lines" are either the result of Line controls or the Line method of
the
report. "spaces" can be either vertical space or horizontal space
between
controls.

Can you provide more details on what you are seeing and would like to
correct?

--
Duane Hookom
MS Access MVP

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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.

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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

"JNana" wrote in message
...
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