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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field size

Status
Not open for further replies.
toyt78

toyt78

Technical User
Joined
Apr 5, 2005
Messages
125
Location
US
What is the maximum size of a memo field in Access 2000. I know text field is 255 characters. What is memo field maximum??
 
Sort by date Sort by votes
per MS Access HELP:

Use the Memo data type if you need to store more than 255 characters. A Memo field can store up to 65,536 characters.
Click to expand...

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
 
Upvote 0 Downvote
For more info on Memo fields

See
faq700-4188




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Field size limit Access 365
Replies
5
Views
6K
TrekBiker
TrekBiker
monkeysee
  • Locked
  • Question Question
Field to count specific records
Replies
3
Views
923
dhookom
dhookom
Lidias13
  • Locked
  • Question Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
747
dhookom
dhookom
HebieBug
  • Locked
  • Question Question
Lookup field in a table will not allow me to use auto expand
Replies
2
Views
568
HebieBug
HebieBug
BugZap13
  • Locked
  • Question Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
5K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top