You should not use a note field unless you a have to. They have a set amount of space they they takeup weather you use all the space or not. Im note sure how much space but i would like to say 1500 characters
On 2 Sep 2003 at 15:49, Fogelson, Steve wrote: > I am new to this list. > > If I have 8 text fields that I want a table to have, would it be better to > use 8 Note fields vs. 8 Text fields of 80 characters? > > Would the Note fields use less disk space that the allocated Text fields of > 80 characters? > > I know this would allow me to use more than 80 characters in some of the > fields, so that would be a benefit. > > Are there any draw backs to a Note field? > > Also, will I lose any data in a Text field that I convert to a Note Field? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
