memo fields with carriage returns won't report complete record

[Guest]

I have a report with a query that concatenates:
1Address: [Address] & " " & [City] & " " & [StateOrProvince] & " " &
[PostalCode] & " " & [CountryRegion]

[Address] is a memo field and whenever a record contains a carriage return
the report only returns the first line.

Any way around this?

Thanks in advance!

 

[Guest]

Try and set the can grow, can shrink property of the field and the section
where the field in, to Yes

 

[Guest]

DOH!!! I was going to do this but I never bothered as the Query View is where
the return problem is.

I guess I worded my question inaccurately. I should've noted that the record
won't return completely in the Query View.

Anyway, things still worked out. It's odd, though that the Query View
doesn't return the complete record.

THANKS!!!

--
www.Marzetti.com

Try and set the can grow, can shrink property of the field and the section
where the field in, to Yes

--
I hope that helped
Good luck

I have a report with a query that concatenates:
1Address: [Address] & " " & [City] & " " & [StateOrProvince] & " " &
[PostalCode] & " " & [CountryRegion]

[Address] is a memo field and whenever a record contains a carriage return
the report only returns the first line.

Any way around this?

Thanks in advance!

 

[John Spencer (MVP)]

Are you sure that the query view isn't returning the entire field? Did you
enlarge the vertical size of the row to see if the information is hidden. Query
view gives you ONLY one vertical size for ALL rows and normally it defaults to
one line in height.

DOH!!! I was going to do this but I never bothered as the Query View is where
the return problem is.

I guess I worded my question inaccurately. I should've noted that the record
won't return completely in the Query View.

Anyway, things still worked out. It's odd, though that the Query View
doesn't return the complete record.

THANKS!!!

--
www.Marzetti.com

Try and set the can grow, can shrink property of the field and the section
where the field in, to Yes

--
I hope that helped
Good luck

I have a report with a query that concatenates:
1Address: [Address] & " " & [City] & " " & [StateOrProvince] & " " &
[PostalCode] & " " & [CountryRegion]

[Address] is a memo field and whenever a record contains a carriage return
the report only returns the first line.

Any way around this?

Thanks in advance!

 

[Guest]

Thanks, John. I took another look and you're correct. I have very little
experience with memo fields in queries so I wasn't aware of this. Now I am
and my brain just expanded yet again with more Access knowledge!

Thanks!

--
www.Marzetti.com

Are you sure that the query view isn't returning the entire field? Did you
enlarge the vertical size of the row to see if the information is hidden. Query
view gives you ONLY one vertical size for ALL rows and normally it defaults to
one line in height.

DOH!!! I was going to do this but I never bothered as the Query View is where
the return problem is.

I guess I worded my question inaccurately. I should've noted that the record
won't return completely in the Query View.

Anyway, things still worked out. It's odd, though that the Query View
doesn't return the complete record.

THANKS!!!

--
www.Marzetti.com

Try and set the can grow, can shrink property of the field and the section
where the field in, to Yes

--
I hope that helped
Good luck


:

I have a report with a query that concatenates:
1Address: [Address] & " " & [City] & " " & [StateOrProvince] & " " &
[PostalCode] & " " & [CountryRegion]

[Address] is a memo field and whenever a record contains a carriage return
the report only returns the first line.

Any way around this?

Thanks in advance!