Removing CRLF in detail section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know how to eliminate the carrage return and line feed from the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
 
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the Chr(13) &
Chr(10)

Duane Hookom said:
Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


johnski said:
I want to know how to eliminate the carrage return and line feed from the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
 
Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

johnski said:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the Chr(13)
&
Chr(10)

Duane Hookom said:
Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


johnski said:
I want to know how to eliminate the carrage return and line feed from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
I use the Len function on productdata which is in the detail section of the
report, I have created a function to combine 8 different fields together. It
appears as though the report automatically fires a CRLF upon completeion of
displaying the data IE there is no CRLF in my data at all and withing my
function I cannot remove them because they appear to be appended after the
function call. I am using access 2003 and if i do WhereCrLf =
Instr([ProductData], Chr(13) & Chr(10)) wherecrlf returns 0, so I suspect
taht my earlier statment of Access appends a crlf after populating data is
correct.


Duane Hookom said:
Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

johnski said:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the Chr(13)
&
Chr(10)

Duane Hookom said:
Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",") in a
function I created that combines 8 fields together I use len theere also, I
am using acccess 2003. In my function I use WhereCrLf = Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends CRLF after
populating the detail section.

Duane Hookom said:
Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

johnski said:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the Chr(13)
&
Chr(10)

Duane Hookom said:
Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
Access doesn't append CRLFs in expressions. This might be the result of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


johnski said:
I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",") in a
function I created that combines 8 fields together I use len theere also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends CRLF
after
populating the detail section.

Duane Hookom said:
Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

johnski said:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
Per my example below after each product is displayed there is a line wrap to
the next product. Does Reports Line wrap after each section IE after each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it line
wraps to the next line wihic is the product detail section, after each
product it line wraps. So again my question would be is there a way to
supress line wraps after each section prints.


Duane Hookom said:
Access doesn't append CRLFs in expressions. This might be the result of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


johnski said:
I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",") in a
function I created that combines 8 fields together I use len theere also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends CRLF
after
populating the detail section.

Duane Hookom said:
Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
I am not sure if you are confused or if I am confused (maybe both). Are
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
contained in different records or values in a single record?

Do you understand that Access reports are "band" based. Each section is a
horizontal band that generally stretchs from the left side of the page to
the right side of the page.

--
Duane Hookom
MS Access MVP
--

johnski said:
Per my example below after each product is displayed there is a line wrap
to
the next product. Does Reports Line wrap after each section IE after each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it line
wraps to the next line wihic is the product detail section, after each
product it line wraps. So again my question would be is there a way to
supress line wraps after each section prints.


Duane Hookom said:
Access doesn't append CRLFs in expressions. This might be the result of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


johnski said:
I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
in a
function I created that combines 8 fields together I use len theere
also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends CRLF
after
populating the detail section.

:

Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed
from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without
salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
Understood, they are different records, so in my example below Beach nut has
4 products and Stages has 3. The Manufacturer is one header and their
products are in the detail section. One manufacturer has many prodcuts some
have few. so you see one beachnut and 4 products below them I want to keep
the detia (product records) together and not have line feeds after each. I
would send the databas but it is 40M is there some other way to show you?

Duane Hookom said:
I am not sure if you are confused or if I am confused (maybe both). Are
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
contained in different records or values in a single record?

Do you understand that Access reports are "band" based. Each section is a
horizontal band that generally stretchs from the left side of the page to
the right side of the page.

--
Duane Hookom
MS Access MVP
--

johnski said:
Per my example below after each product is displayed there is a line wrap
to
the next product. Does Reports Line wrap after each section IE after each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it line
wraps to the next line wihic is the product detail section, after each
product it line wraps. So again my question would be is there a way to
supress line wraps after each section prints.
Baby Foods in jars without salicylate
Click to expand...


Duane Hookom said:
Access doesn't append CRLFs in expressions. This might be the result of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
in a
function I created that combines 8 fields together I use len theere
also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends CRLF
after
populating the detail section.

:

Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line feed
from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without
salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
There are no CRLFs in this. Access just prints reports in horizontal bands.
If you want to combine field values from multiple records, there is a
generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You could also remove the details from your main report and place them in a
multi-column subreport.

--
Duane Hookom
MS Access MVP


johnski said:
Understood, they are different records, so in my example below Beach nut
has
4 products and Stages has 3. The Manufacturer is one header and their
products are in the detail section. One manufacturer has many prodcuts
some
have few. so you see one beachnut and 4 products below them I want to keep
the detia (product records) together and not have line feeds after each. I
would send the databas but it is 40M is there some other way to show you?

Duane Hookom said:
I am not sure if you are confused or if I am confused (maybe both). Are
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
contained in different records or values in a single record?

Do you understand that Access reports are "band" based. Each section is a
horizontal band that generally stretchs from the left side of the page to
the right side of the page.

--
Duane Hookom
MS Access MVP
--

johnski said:
Per my example below after each product is displayed there is a line
wrap
to
the next product. Does Reports Line wrap after each section IE after
each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it
line
wraps to the next line wihic is the product detail section, after each
product it line wraps. So again my question would be is there a way to
supress line wraps after each section prints.

Baby Foods in jars without salicylate


:

Access doesn't append CRLFs in expressions. This might be the result
of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10),
",")
in a
function I created that combines 8 fields together I use len theere
also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends
CRLF
after
populating the detail section.

:

Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line
feed
from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without
salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
Per your example, you do not do anything with reports but as an example what
if you did the faimilyID as a reoprt header, family last name as a subheader,
and first name as detail like so

1
Hokam
Duane,Laura,Jake,Chelsey,Dakota,Josie,Jackson

How would you accomplish that?

Duane Hookom said:
There are no CRLFs in this. Access just prints reports in horizontal bands.
If you want to combine field values from multiple records, there is a
generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You could also remove the details from your main report and place them in a
multi-column subreport.

--
Duane Hookom
MS Access MVP


johnski said:
Understood, they are different records, so in my example below Beach nut
has
4 products and Stages has 3. The Manufacturer is one header and their
products are in the detail section. One manufacturer has many prodcuts
some
have few. so you see one beachnut and 4 products below them I want to keep
the detia (product records) together and not have line feeds after each. I
would send the databas but it is 40M is there some other way to show you?

Duane Hookom said:
I am not sure if you are confused or if I am confused (maybe both). Are
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
contained in different records or values in a single record?

Do you understand that Access reports are "band" based. Each section is a
horizontal band that generally stretchs from the left side of the page to
the right side of the page.

--
Duane Hookom
MS Access MVP
--

Per my example below after each product is displayed there is a line
wrap
to
the next product. Does Reports Line wrap after each section IE after
each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it
line
wraps to the next line wihic is the product detail section, after each
product it line wraps. So again my question would be is there a way to
supress line wraps after each section prints.

Baby Foods in jars without salicylate


:

Access doesn't append CRLFs in expressions. This might be the result
of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10),
",")
in a
function I created that combines 8 fields together I use len theere
also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access appends
CRLF
after
populating the detail section.

:

Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


I want to know how to eliminate the carrage return and line
feed
from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without
salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
You could add a text box in the section where you want the names listed
together. Set the control source to something like:
=Concatenate("SELECT FirstName FROM tblFamilyMembers WHERE FamID = " &
[FamID])

--
Duane Hookom
MS Access MVP


johnski said:
Per your example, you do not do anything with reports but as an example
what
if you did the faimilyID as a reoprt header, family last name as a
subheader,
and first name as detail like so

1
Hokam
Duane,Laura,Jake,Chelsey,Dakota,Josie,Jackson

How would you accomplish that?

Duane Hookom said:
There are no CRLFs in this. Access just prints reports in horizontal
bands.
If you want to combine field values from multiple records, there is a
generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

You could also remove the details from your main report and place them in
a
multi-column subreport.

--
Duane Hookom
MS Access MVP


johnski said:
Understood, they are different records, so in my example below Beach
nut
has
4 products and Stages has 3. The Manufacturer is one header and their
products are in the detail section. One manufacturer has many prodcuts
some
have few. so you see one beachnut and 4 products below them I want to
keep
the detia (product records) together and not have line feeds after
each. I
would send the databas but it is 40M is there some other way to show
you?

:

I am not sure if you are confused or if I am confused (maybe both).
Are
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
contained in different records or values in a single record?

Do you understand that Access reports are "band" based. Each section
is a
horizontal band that generally stretchs from the left side of the page
to
the right side of the page.

--
Duane Hookom
MS Access MVP
--

Per my example below after each product is displayed there is a line
wrap
to
the next product. Does Reports Line wrap after each section IE after
each
header then detail then foooter does a line wrap occur?

BEECH-NUT this is the manufacturer header after this is displayed it
line
wraps to the next line wihic is the product detail section, after
each
product it line wraps. So again my question would be is there a way
to
supress line wraps after each section prints.

Baby Foods in jars without salicylate


:

Access doesn't append CRLFs in expressions. This might be the
result
of
line-wrap. What makes you think there is a CRLF in the text?

--
Duane Hookom
MS Access MVP


I am using Detaillayout = Replace(productdata, Chr(13) & Chr(10),
",")
in a
function I created that combines 8 fields together I use len
theere
also,
I
am using acccess 2003. In my function I use WhereCrLf =
Instr([ProductData],
Chr(13) & Chr(10)) and it returns 0. I suspect that access
appends
CRLF
after
populating the detail section.

:

Where are you using:
Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")
Assigning a value to a variable usually occurs in code.

What field are you using in LEN()?

What version of Access are you using?

What happens if you add a column to your query:
WhereCrLf: Instr([ProductData], Chr(13) & Chr(10))
or
WhereCr: Instr([ProductData], Chr(13))
or
WhereLf: Instr([ProductData], Chr(10))

--
Duane Hookom
MS Access MVP
--

Detaillayout = Replace(productdata, Chr(13) & Chr(10), ",")

Does not work, when you LEN(field) it shows only the data not
the
Chr(13)
&
Chr(10)

:

Have you tried something like:
=Replace([YourField],Chr(13) & Chr(10), " ")

--
Duane Hookom
MS Access MVP


message
I want to know how to eliminate the carrage return and line
feed
from
the
detail section, currently the data looks like this
BEECH-NUT
Baby Foods in jars without salicylate
Rice Cereal with Bananas
Toddler Foods in jars without salicylate
STAGES
Barley Cereal
Mixed Cereal
Pear Juice

When I would like it to look like this
BEECH-NUT Baby Foods in jars without salicylate,
Rice Cereal with Bananas, Toddler Foods in jars without
salicylate
STAGES Barley Cereal, Mixed Cereal, Pear Juice
Click to expand...
Click to expand...
Click to expand...
 
Back
Top