Concatenating Memo & Text Fields

[Vel]

Hello,

I was wondering if there was a way to concatenate a long
memo field and a text field. For example, I want a memo
field to be the first line in a text box on my report.
The problem is that, if the memo field exceeds a certain
number of characters it gets cut off, then the other
information is stuck in right after it.

Vel

 

[Marshall Barton]

I was wondering if there was a way to concatenate a long
memo field and a text field. For example, I want a memo
field to be the first line in a text box on my report.
The problem is that, if the memo field exceeds a certain
number of characters it gets cut off, then the other
information is stuck in right after it.

FIrst thing to do is make sure that the report's text box
has its CanGrow property set to Yes and that its Format
property is blank.

If that doesn't do it, check the report's record source
query to see if the memo field is truncated (to 255
characters) before it gets to the report. If it is, the
problem is probably caused by the use of the memo field in a
Group By or Order By clause. If you can't spot the problem,
post the query so someone can try to analyze it.

 

[Vel]

That did the trick. Thanks.

It's funny, I've been using Access for nearly 3 years now
with a significant amount of formal training, and have
always just thought that the queries without the totals
visible were just like the ones with the totals, only
with the totals hidden. I never realized that they were
then considered "grouping" queries... The distinction
was just never made...

Vel.

-----Original Message-----

It is in the GROUP BY clause. Where else can I put it?

There is almost no good reason to use a grouping query with
a memo field. See if you can leave it out of the grouping
query and Join it back in with another query based on the
grouping query and the table containing the memo field.

If that doesn't meet your needs, please post a copy of the
SQL view of your query and identify the primary key of each
table in the query.
--
Marsh
MVP [MS Access]

field
in a

.

 

[Rick Brandt]

That did the trick. Thanks.

It's funny, I've been using Access for nearly 3 years now
with a significant amount of formal training, and have
always just thought that the queries without the totals
visible were just like the ones with the totals, only
with the totals hidden. I never realized that they were
then considered "grouping" queries... The distinction
was just never made...

Vel.

Another bad interface decision by MS (IMO). A Totals query should be specified as a
query "Type" not with the misleading "View - Totals". Because you're right. There
is another option "View - Table Names" that has no affect whatsoever on the query's
output or function. You're just hiding or displaying a row in the design grid. The
"View - Totals" menu option could easily be interpreted the same way.