> Also, the *default* field size of a text field in a table is 50 chars. You
> can change this to a max of 255 chars.
>> Also, the *default* field size of a text field in a table is 50 chars. You
>> can change this to a max of 255 chars.
>
>Heh, thanks, but no, it needs more - it's for recording
>recommendations following complaints about government offices. 255
>characters doesn't get _close_. ;)
You can use a Memo field - that gives you 65536 characters (or two billion, if
you fill the field programmatically). That should give you a couple of weeks
worth of complaints about government offices... of course you'll need
SQL/Server and a BIG disk farm to hold all complaints about all offices!!
John W. Vinson [MVP]
SteveS - 12 May 2007 08:54 GMT
Sad.........very True, but sad...
(I will not rant, I will not rant, ...)

Signature
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)
> >> Also, the *default* field size of a text field in a table is 50 chars. You
> >> can change this to a max of 255 chars.
[quoted text clipped - 9 lines]
>
> John W. Vinson [MVP]
Cranky - 14 May 2007 23:02 GMT
> You can use a Memo field - that gives you 65536 characters (or two billion, if
> you fill the field programmatically). That should give you a couple of weeks
> worth of complaints about government offices... of course you'll need
> SQL/Server and a BIG disk farm to hold all complaints about all offices!!
Well... it's local government, so not _quite_ as bad...