Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field size limit Access 365

Status
Not open for further replies.
TrekBiker

TrekBiker

Technical User
Nov 26, 2010
334
GB

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

Yes, but the Long Text field is still limited to 255 characters.
 
Upvote 0 Downvote
Not according to the info in the link combo provided:

Long Text said:
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 [blue]about a gigabyte of text[/blue], even though controls on forms and reports can only display the first [blue]64,000 characters[/blue]. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.
Click to expand...

---- Andy

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

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.
 
Upvote 0 Downvote

Yes confirmed, second go gives full lengths. Apologies again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
652
dhookom
dhookom
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
7K
Anthony343242
Anthony343242
BugZap13
  • Locked
  • Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
4K
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
543
dhookom
dhookom
HebieBug
  • Locked
  • Question
Lookup field in a table will not allow me to use auto expand 1
Replies
2
Views
392
HebieBug
HebieBug

Part and Inventory Search

Sponsor

Back
Top