Changing Default value of Memo field

[hefly]

How do you change the default value of a memo field. Apparently the default value is 255 characters.

If you change it to a greater value than default, will that delete the data that is already in the field?

Thank you.

Hefly

 

[dhookom]

You may need to store and retrieve the value from a field in a table.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

By 'value', do you really mean 'size'?

Just guessing here...

Have fun.

---- Andy

 

[hefly]

I have refined my problem...

The memo field is not truncating. I base my form off of a query. It is the query that is truncating the data in the memo field.

Is there a way around truncating memo fields in q query?

How do you access the data in your memo field if a query truncates it?

Hefly

 

[PHV]

To avoid truncation of a memo field in a query you don't use the DISTINCT predicate nor GROUP BYthis field nor use any aggregate function on it.
What is the SQL code of your query and the name of the memo field ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hefly]

the field that is truncating is description. My form and reports derive its data from the query.

I find that if I export to MS Word, all the data, including a record with more than 255 characters, is exported. I just can't see it on the form or report.
Below is the field "description" Most records are less than 255 characters, but for ease of observation, I restricted the query to records > 400 characters.


SELECT tblLseTracts.Description, Len([description]) AS [Char]
FROM tblLseTracts
WHERE (((Len([description]))>400));

Thank you.

Hefly

 

[dhookom]

Are you suggesting the Description gets truncated in the provided SQL statement?

Setting the Format property of a control on a form or report will also truncate the value. Text values in Group Headers or Footers may also be truncated.

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

Yes. The query as above written returns truncated records.

Hefly

 

[dhookom]

Check the table design of tblLseTracts and look for anything in the Format property of the Description field. If there is something there, remove it. There might even be a space hidden there.

Duane
Hook'D on Access
MS Access MVP