A text-field of 512 characters

  • Thread starter Thread starter Rob Berkers
  • Start date Start date
R

Rob Berkers

Hello everybody,

I need to export a file. This file will be imported into a (none
Access) application.

In this file I need two text-file of 512 chacters each. But Access
only allows me to create a text of 255 maximum.

Does anyone know a trick to create a textfile of 512 charactes anyway?

Thanks.

Rob.
 
Text fields have a limit of 255 characters.

To get more in a single field, you need to use a Memo field.
 
Does anyone know a trick to create a textfile of 512 charactes anyway?

Memo fields will allow 65536 characters (actually a gigabyte if you populate
it programmatically). Just change the datatype of the field (not "file",
Access doesn't contain files) to Memo.

John W. Vinson [MVP]
 
Back
Top