Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Made fields smaller, .MDB isn't smaller
Message
From
22/05/2002 14:47:16
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00659514
Message ID:
00660090
Views:
19
This message has been marked as the solution to the initial question of the thread.
No, I am saying that you can store up to a mximum of 255 characters in a text field. "Jason" is going to be stored as 5 characters while "Jas" will only be stored as 3 characters. Maybe this will help:

Field MyField is a text field with a max length of 255. I store the word "banana" in this field. There is now 6 characters stored in this field occupying 48 bits. Changing the max length to 6 does not affect the size as it is still only 48 bits. Max length only defines how many characters can be stored; it does not affect the actual size of the memory location.
Previous
Reply
Map
View

Click here to load this message in the networking platform