Truncated Text Box on Report

I have a field from a query where I have concatenated multiple fields to show
(Part Numbers, Operations and Inventory amounts on hand) for all components
of a finished part number where I'm using ** as a spacer between each set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect. up
to 25 sets). This concatenated field is attached in a query by a job and
finished part number.

I've done this to be able to include this info as a single line in a very
complicated report. The report has no groupings, but is sorted by Job Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?

I've read some other threads and have seen that I may need to format the text
box as memo. However, in it's properties, there is no drop down for the
format field. How can I format it?

"neenmarie" wrote:

I have a field from a query where I have concatenated multiple fields to show
(Part Numbers, Operations and Inventory amounts on hand) for all components
of a finished part number where I'm using ** as a spacer between each set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect. up
to 25 sets). This concatenated field is attached in a query by a job and
finished part number.

I've done this to be able to include this info as a single line in a very
complicated report. The report has no groupings, but is sorted by Job Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?

neenmarie wrote:
I've read some other threads and have seen that I may need to format
the text box as memo. However, in it's properties, there is no drop
down for the format field. How can I format it?

Memo is not a format, it is a data type. You need to change the design of
the table and make the field a memo data type instead of Text.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

This is a field in a query to combines both text and number fields. How can
I change the combined field to a memo type?

"Rick Brandt" wrote:

neenmarie wrote:
I've read some other threads and have seen that I may need to format
the text box as memo. However, in it's properties, there is no drop
down for the format field. How can I format it?

Memo is not a format, it is a data type. You need to change the design of
the table and make the field a memo data type instead of Text.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Have you set any value in the Format property of the text box? Is the text
box Can Grow property set to Yes?

--
Duane Hookom
MS Access MVP


"neenmarie" wrote in message
...
I have a field from a query where I have concatenated multiple fields to
show
(Part Numbers, Operations and Inventory amounts on hand) for all
components
of a finished part number where I'm using ** as a spacer between each set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect.
up
to 25 sets). This concatenated field is attached in a query by a job and
finished part number.

I've done this to be able to include this info as a single line in a very
complicated report. The report has no groupings, but is sorted by Job
Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being
truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?

neenmarie wrote:
This is a field in a query to combines both text and number fields.
How can I change the combined field to a memo type?

Truncation should not be a problem in the scenario you are describing. What
is the query expression?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

I have a field from a query where I have concatenated multiple fields to show
(Part Numbers, Operations and Inventory amounts on hand) for all components
of a finished part number where I'm using ** as a spacer between each set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect. up
to 25 sets). This concatenated field is attached in a query by a job and
finished part number.

I've done this to be able to include this info as a single line in a very
complicated report. The report has no groupings, but is sorted by Job Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?


"Rick Brandt" wrote:

neenmarie wrote:
This is a field in a query to combines both text and number fields.
How can I change the combined field to a memo type?

Truncation should not be a problem in the scenario you are describing. What
is the query expression?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

I've put nothing in the Format property. And, there is nothing in the drop
down there.
The Property is set to Yes.


"Duane Hookom" wrote:

Have you set any value in the Format property of the text box? Is the text
box Can Grow property set to Yes?

--
Duane Hookom
MS Access MVP


"neenmarie" wrote in message
...
I have a field from a query where I have concatenated multiple fields to
show
(Part Numbers, Operations and Inventory amounts on hand) for all
components
of a finished part number where I'm using ** as a spacer between each set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect.
up
to 25 sets). This concatenated field is attached in a query by a job and
finished part number.

I've done this to be able to include this info as a single line in a very
complicated report. The report has no groupings, but is sorted by Job
Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being
truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?

Is your text always truncating at about 255 characters? Is the text box in
the detail section or a header/footer?

--
Duane Hookom
MS Access MVP
--

"neenmarie" wrote in message
...
I've put nothing in the Format property. And, there is nothing in the
drop
down there.
The Property is set to Yes.


"Duane Hookom" wrote:

Have you set any value in the Format property of the text box? Is the
text
box Can Grow property set to Yes?

--
Duane Hookom
MS Access MVP


"neenmarie" wrote in message
...
I have a field from a query where I have concatenated multiple fields to
show
(Part Numbers, Operations and Inventory amounts on hand) for all
components
of a finished part number where I'm using ** as a spacer between each
set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect.
up
to 25 sets). This concatenated field is attached in a query by a job
and
finished part number.

I've done this to be able to include this info as a single line in a
very
complicated report. The report has no groupings, but is sorted by Job
Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being
truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?

Yes, is truncating at 255 and is in the detail section.

"Duane Hookom" wrote:

Is your text always truncating at about 255 characters? Is the text box in
the detail section or a header/footer?

--
Duane Hookom
MS Access MVP
--

"neenmarie" wrote in message
...
I've put nothing in the Format property. And, there is nothing in the
drop
down there.
The Property is set to Yes.


"Duane Hookom" wrote:

Have you set any value in the Format property of the text box? Is the
text
box Can Grow property set to Yes?

--
Duane Hookom
MS Access MVP


"neenmarie" wrote in message
...
I have a field from a query where I have concatenated multiple fields to
show
(Part Numbers, Operations and Inventory amounts on hand) for all
components
of a finished part number where I'm using ** as a spacer between each
set.

([P1]&"-"&[O1]&"/"&[Inv1]&"**"&[P2]&"-"&[O2]&"/"&[Inv2]&"**"&[P3]....ect.
up
to 25 sets). This concatenated field is attached in a query by a job
and
finished part number.

I've done this to be able to include this info as a single line in a
very
complicated report. The report has no groupings, but is sorted by Job
Number
and Part Number.

All the info I'm seeking is showing up in the query, but is being
truncated
on the report.

Any idea what I can do to show all the data from the query field on the
report?