|
| 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
January 11th, 2010, 03:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Memo Field Limited to 256 Characters?
I'm creating a report, imported from Excel, that contains a large
"Description" field. ACCESS wants to limit me to only 256 characters in that field. Is this correct? Is there a work-around? TIA. 
|
|
#2
January 11th, 2010, 04:34 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Memo Field Limited to 256 Characters?
memo fields actually support something like 63256 characters. are
you sure it is not set as a Text field? those are limited to 255.
|
|
#3
January 12th, 2010, 12:27 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Memo Field Limited to 256 Characters?
On 1/11/2010 11:34 AM, ghetto_banjo wrote:
memo fields actually support something like 63256 characters. are you sure it is not set as a Text field? those are limited to 255. Good point. I'll check. That 256 char limit just didn't seem right. Thanks.
|
|
#4
January 12th, 2010, 12:51 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Memo Field Limited to 256 Characters?
On Mon, 11 Jan 2010 19:27:19 -0500, Jethro Pull wrote:
On 1/11/2010 11:34 AM, ghetto_banjo wrote: memo fields actually support something like 63256 characters. are you sure it is not set as a Text field? those are limited to 255. Good point. I'll check. That 256 char limit just didn't seem right. Thanks. A Memo can actually contain up to two gigabytes (though if you did that there'd be no room for anything else in the database), if you populate the field programmatically. One possible issue is that if you apply a Format to the memo field (whether in the table properties, the query field properties, or the form/report textbox properties); or if you try to sort the query by the memo field - you'll be truncated to 255. -- John W. Vinson [MVP]
|
|
#5
January 12th, 2010, 08:18 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Memo Field Limited to 256 Characters?
On 1/11/2010 7:51 PM, John W. Vinson wrote:
On Mon, 11 Jan 2010 19:27:19 -0500, Jethro wrote: On 1/11/2010 11:34 AM, ghetto_banjo wrote: memo fields actually support something like 63256 characters. are you sure it is not set as a Text field? those are limited to 255. Good point. I'll check. That 256 char limit just didn't seem right. Thanks. A Memo can actually contain up to two gigabytes (though if you did that there'd be no room for anything else in the database), if you populate the field programmatically. One possible issue is that if you apply a Format to the memo field (whether in the table properties, the query field properties, or the form/report textbox properties); or if you try to sort the query by the memo field - you'll be truncated to 255. Good point. I probably had a sort box checked. I used to be a heavy A-T DB IV user and ACCESS is a new learning curve. Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
