Prev: Two databases or one
Next: Questions on SQL Server
From: WSR on 6 Apr 2010 09:25
I'm creating a database of text fields. I expect some data to exceed 255
characters.

What is the maximum field size of a text field? Can I increase the text
field size?

If so I can I do that?

Your help is appreciated.

Regards,

(B^>)-]=[


From: KARL DEWEY on 6 Apr 2010 10:38
Use a memo field.
But remember there are limitations and using functions with a memo as you
cannot sort it. If you use Left([YourMemo], 255) you can sort that.

--
Build a little, test a little.


"WSR" wrote:

> I'm creating a database of text fields. I expect some data to exceed 255
> characters.
>
> What is the maximum field size of a text field? Can I increase the text
> field size?
>
> If so I can I do that?
>
> Your help is appreciated.
>
> Regards,
>
> (B^>)-]=[
>
>
> .
>
From: WSR on 6 Apr 2010 10:41
Thanks for replying to a level 100 question!

Regards,

(B^>)-]=[

"KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message
news:41F1AB8F-56CC-4F0B-A5CC-BB04EDF824C8(a)microsoft.com...
> Use a memo field.
> But remember there are limitations and using functions with a memo as you
> cannot sort it. If you use Left([YourMemo], 255) you can sort that.
>
> --
> Build a little, test a little.
>
>
> "WSR" wrote:
>
>> I'm creating a database of text fields. I expect some data to exceed 255
>> characters.
>>
>> What is the maximum field size of a text field? Can I increase the text
>> field size?
>>
>> If so I can I do that?
>>
>> Your help is appreciated.
>>
>> Regards,
>>
>> (B^>)-]=[
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Two databases or one
Next: Questions on SQL Server