Contact US

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.

Students Click Here

Field size limit Access 365

Field size limit Access 365

Field size limit Access 365


Is there a way around the maximum field size of 255 characters in Access 365. The old Memo field allowed this.

RE: Field size limit Access 365


Yes, but the Long Text field is still limited to 255 characters.

RE: Field size limit Access 365

Not according to the info in the link combo provided:

Quote (Long Text)

Long Text In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000 characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Field size limit Access 365


Ah, apologies, I tried importing the data again and got the full length using Long Text. I have two sets of data to import and then merge so will check if this caused the reduction to 255 characters. Either that or plain human error. Many thanks.

RE: Field size limit Access 365


Yes confirmed, second go gives full lengths. Apologies again.

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! Already a Member? Login

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