Memo - Text fields

[Mike]

Hello,

I have a strange problem that's happening using a memo field in Access 2002. We have two tables that are connected through a common link. The first table contains all our project information and the second simply contains a project description (scope). The project scope is rather lengthy (more than 255 characters) so we need to use the memo field (max 64,000 characters).

I have no problems querying on the data if the data type of the scope field is "text". However, I run into problems if the data type is "memo". The query will pull the information without a problem, but the scope field will spit out information that looks like a square - à°€ - followed by a lower-case r. I've tried formatting the table column under the general settings with an "@" sign and/or an "&" sign.

I'm left scratching my head with a bewildered look on my face (per my boss). Any suggestions?

Thank you!

Mike

 

[Allen Browne]

Using the Format property of the field in the table will cause it to
truncate at 255 chars.

So will any kind of aggregation on the memo field in the query, e.g. if it
contains a DISTINCT predicate or a GROUP BY clause. For a Totals query, try
"First" in the Total row under the memo field.

If there are still strange characters in the field, they may need to be
replaced. To identify what it is, try copying the square box to clipboard.
Then open the Immediate Window (Ctrl+G), and enter:
? Asc("")
Place the cursor inside the quotes, and paste in the character. Press Enter
at the end of the line, and hopefully you will know what character this is.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hello,

I have a strange problem that's happening using a memo field in Access

2002. We have two tables that are connected through a common link. The
first table contains all our project information and the second simply
contains a project description (scope). The project scope is rather lengthy
(more than 255 characters) so we need to use the memo field (max 64,000
characters).

I have no problems querying on the data if the data type of the scope

field is "text". However, I run into problems if the data type is "memo".
The query will pull the information without a problem, but the scope field
will spit out information that looks like a square - ? - followed by a
lower-case r. I've tried formatting the table column under the general
settings with an "@" sign and/or an "&" sign.

 

[Mike]

Allen,

Thanks for the information. I am running a totals query and changing the group by function to FIRST did the trick.