Prev: After Update If
Next: how to maximize on load
From: Jethro Pull on 11 Jan 2010 10:21
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.
From: ghetto_banjo on 11 Jan 2010 11:34
memo fields actually support something like 63256 characters. are
you sure it is not set as a Text field? those are limited to 255.
From: Jethro Pull on 11 Jan 2010 19:27
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.
From: John W. Vinson on 11 Jan 2010 19:51
On Mon, 11 Jan 2010 19:27:19 -0500, Jethro Pull <jpull(a)hotmail.com> 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]
From: Jethro Pull on 12 Jan 2010 15:18
On 1/11/2010 7:51 PM, John W. Vinson wrote:
> On Mon, 11 Jan 2010 19:27:19 -0500, Jethro Pull<jpull(a)hotmail.com> 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.
 | 
Pages: 1
Prev: After Update If
Next: how to maximize on load