Variable length records

[Shellie]

Hello

Would it be possible for someone to explain to me how to program a variable length text fields in a table, as opposed to a fixed length field?

Also - what would be the disadvantage of using this type of field ?

Thanks
Shellie

 

[Pat Hartman]

If you are talking about Access, it doesn't have both a Char and VarChar datatype so there is no way to "program" it. If you are using SQL Server or some other back end database, just use the variable length text data type. There is no programming involved.