Text Field Size - Access 2007

  • Thread starter Thread starter WSR
  • Start date Start date
W

WSR

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^>)-]=[
 
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.
 
Thanks for replying to a level 100 question!

Regards,

(B^>)-]=[

KARL DEWEY said:
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 said:
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^>)-]=[


.
Click to expand...
Click to expand...
 
Back
Top