INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Changing Default value of Memo field

Changing Default value of Memo field

(OP)
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





RE: Changing Default value of Memo field

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

Duane
Hook'D on Access
MS Access MVP

RE: Changing Default value of Memo field

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

Just guessing here...

Have fun.

---- Andy

RE: Changing Default value of Memo field

(OP)
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

RE: Changing Default value of Memo field

(OP)
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

RE: Changing Default value of Memo field

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

RE: Changing Default value of Memo field

(OP)
Yes. The query as above written returns truncated records.

Hefly

RE: Changing Default value of Memo field

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close