Carriage Returns in my data as a box

[ChuckW]

Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa +
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck

 

[Duane Hookom]

It's difficult to tell without knowing the ascii value of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr(10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr(10))

 

[Guest]

Duane,

Thanks for your help. I placed the code you suggested
into the criteria section of my query and replaced
YourMultipleValueField with Desc which is the memo field
that has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]![CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr(10),Chr
(13) & Chr(10))));

When I tried to run this, I got an error that said thee
expression is either typed incorrectly or is too
complex. Am I doing this correctly?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr (10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr (10))

--
Duane Hookom
MS Access MVP
--

Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa +
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck

.

 

[ChuckW]

Duane,

I added the code you suggested into the criteria section
of my query (I tried both suggestions). I replaced
YourMultipleValueField with DESC which is the field that
has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]![CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr(10),Chr
(13) & Chr(10))));

When I tried to run this I got an error that said the
expression is either typed incorrectly or is too
complex. Any idea what I am doing wrong?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr (10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr (10))

--
Duane Hookom
MS Access MVP
--

Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa +
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck

.

 

[Duane Hookom]

I don't recall suggesting anything regarding criteria. My solution was to
replace the control source of a text box in your report with:
=Replace([Desc],Chr(10),Chr(13) & Chr(10))

--
Duane Hookom
MS Access MVP

Duane,

Thanks for your help. I placed the code you suggested
into the criteria section of my query and replaced
YourMultipleValueField with Desc which is the memo field
that has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]![CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr(10),Chr
(13) & Chr(10))));

When I tried to run this, I got an error that said thee
expression is either typed incorrectly or is too
complex. Am I doing this correctly?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr (10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr (10))

--
Duane Hookom
MS Access MVP
--

Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa +
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck

.

 

[ChuckW]

Duane,

Still having problems getting this to work. The data
comes from Quickbooks. I use a program called Access
Books that takes data out of Quickbooks and places it
into Access. Whenever I try the two suggestions, I
simply get an error in my report field. I read some
things in the microsoft knowledge base on this. It was
mainly about how to deal with it when you import. The
import is done by this access books program and I cant
make this change while importing.

Thanks,

Chuck

-----Original Message-----
I don't recall suggesting anything regarding criteria. My solution was to
replace the control source of a text box in your report with:
=Replace([Desc],Chr(10),Chr(13) & Chr(10))

--
Duane Hookom
MS Access MVP

Duane,

Thanks for your help. I placed the code you suggested
into the criteria section of my query and replaced
YourMultipleValueField with Desc which is the memo field
that has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]! [CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr(10),Chr
(13) & Chr(10))));

When I tried to run this, I got an error that said thee
expression is either typed incorrectly or is too
complex. Am I doing this correctly?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) &

Chr
(10))

If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) &

Chr
(10))

--
Duane Hookom
MS Access MVP
--

Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to

create
a

report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by

Lisa
+

Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck


.

.

 

[Duane Hookom]

Make sure the name of your control is not the name of a field in your record
source. What is the exact control source that you are using?

--
Duane Hookom
MS Access MVP
--

Duane,

Still having problems getting this to work. The data
comes from Quickbooks. I use a program called Access
Books that takes data out of Quickbooks and places it
into Access. Whenever I try the two suggestions, I
simply get an error in my report field. I read some
things in the microsoft knowledge base on this. It was
mainly about how to deal with it when you import. The
import is done by this access books program and I cant
make this change while importing.

Thanks,

Chuck

-----Original Message-----
I don't recall suggesting anything regarding criteria. My solution was to
replace the control source of a text box in your report with:
=Replace([Desc],Chr(10),Chr(13) & Chr(10))

--
Duane Hookom
MS Access MVP

Duane,

Thanks for your help. I placed the code you suggested
into the criteria section of my query and replaced
YourMultipleValueField with Desc which is the memo field
that has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]! [CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr(10),Chr
(13) & Chr(10))));

When I tried to run this, I got an error that said thee
expression is either typed incorrectly or is too
complex. Am I doing this correctly?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value
of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr
(10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr
(10))

--
Duane Hookom
MS Access MVP
--

message
Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create
a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage
returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa
+
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck


.

.

 

[ChuckW]

Duane,

Your suggestion worked. The problem was the name of my
control source was the same as the name of my field. I
renamed my text box to Description and my control source
to =Replace([Desc],Chr(10),Chr(13) & Chr(10)) and it
worked.

Thanks,

Chuck

-----Original Message-----
Make sure the name of your control is not the name of a field in your record
source. What is the exact control source that you are using?

--
Duane Hookom
MS Access MVP
--

Duane,

Still having problems getting this to work. The data
comes from Quickbooks. I use a program called Access
Books that takes data out of Quickbooks and places it
into Access. Whenever I try the two suggestions, I
simply get an error in my report field. I read some
things in the microsoft knowledge base on this. It was
mainly about how to deal with it when you import. The
import is done by this access books program and I cant
make this change while importing.

Thanks,

Chuck

-----Original Message-----
I don't recall suggesting anything regarding criteria. My solution was to
replace the control source of a text box in your report with:
=Replace([Desc],Chr(10),Chr(13) & Chr(10))

--
Duane Hookom
MS Access MVP


Duane,

Thanks for your help. I placed the code you suggested
into the criteria section of my query and replaced
YourMultipleValueField with Desc which is the memo field
that has the boxes in it. Here is my SQL:

SELECT CreditMemo.CustomerRef_FullName,
CreditMemo.TxnDate,
CreditMemoLineDetail.ItemRef_FullName,
CreditMemoLineDetail.Desc
FROM CreditMemo INNER JOIN CreditMemoLineDetail ON
CreditMemo.TxnID = CreditMemoLineDetail.IDKEY
WHERE (((CreditMemo.TxnDate) Between [Forms]! [CMReport]!
[txtStartDate] And [Forms]![CMReport]![txtEndDate]) AND
((CreditMemoLineDetail.ItemRef_FullName) Like "*CM*") AND
((CreditMemoLineDetail.Desc)=Replace([Desc],Chr (10),Chr
(13) & Chr(10))));

When I tried to run this, I got an error that said thee
expression is either typed incorrectly or is too
complex. Am I doing this correctly?

Thanks,

Chuck

-----Original Message-----
It's difficult to tell without knowing the ascii value
of the boxes. I
expect they might be Chr(13). You can try use
=Replace([YourMultipleValueField],Chr(13), Chr(13) & Chr
(10))
If that doesn't work, try:
=Replace([YourMultipleValueField],Chr(10), Chr(13) & Chr
(10))

--
Duane Hookom
MS Access MVP
--

message
Hi,

I have a memo field that contains information that a
customer service person typed in. There are carriage
returns in it which appear as boxes. I want to create
a
report and somehow get the data to appear on separate
lines based on these carriage returns. Right now
everything is on one line that has the carriage
returns.
So my data looks like this (the plus signs are actually
carriage returns and look like boxes in my data):

Order Taken by Fred + Packed By Bill + Checked by Lisa
+
Shipped by John

I would like on my report for the data to appear like
this:



Order Taken By Fred
Packed By Bill
Checked By Lisa
Shipped by John

Does anyone know how to do this?

Thanks,

Chuck


.



.

.