memo fields with carriage returns won't report complete record

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

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!
 
Try and set the can grow, can shrink property of the field and the section
where the field in, to Yes
 
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


Ofer said:
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


JohnLute said:
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!
Click to expand...
Click to expand...
 
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

Ofer said:
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


JohnLute said:
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!
Click to expand...
Click to expand...
Click to expand...
 
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


John Spencer (MVP) said:
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

Ofer said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top