If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text Field Size - Access 2007
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^)-]=[ |
#2
|
|||
|
|||
Text Field Size - Access 2007
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^)-]=[ . |
#3
|
|||
|
|||
Text Field Size - Access 2007
Thanks for replying to a level 100 question!
Regards, (B^)-]=[ "KARL DEWEY" wrote in message ... 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^)-]=[ . |
Thread Tools | |
Display Modes | |
|
|