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!

  • Congratulations SkipVought 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

Technical User
Nov 26, 2010
330
0
16
GB

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

Yes, but the Long Text field is still limited to 255 characters.
 
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.

---- Andy

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

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.
 

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

Part and Inventory Search

Sponsor

Back
Top