Best way to store long filenames/paths

[Joe Holzhauer]

I'm storing some fairly long filenames/paths in a table (they easily exceed
the 255 character limit for Text fields). Does using a Memo field
unnecessarily increase database size? Is there a better alternative?

Thanks for your advice,
Joe

 

[SuzyQ]

This is from the "About data types and field sizes" in access help.

"Both Text and Memo data types store only the characters entered in a field;
space characters for unused positions in the field aren't stored."