Group:  Microsoft Access ยป microsoft.public.access.gettingstarted
Thread: memo field

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

memo field
Dcbrown428 03.08.2006 15:26:02
I thought I posted this, but can't find my posting so please forgive if this
is a duplicate. I have a field that I need to change from text to memo to
allow additional characters. I have gone in under table design and changed
it to memo, but it will still halt the characters at 255. What am I doing
wrong?
RE: memo field
Ofer Cohen 03.08.2006 15:49:02
The link to your previous post
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access.forms&mid=78c7df7b-204b-4a1b-9c6e-0872b21d098f

--
Good Luck
BS"D


"Dcbrown428" wrote:

[Quoted Text]
> I thought I posted this, but can't find my posting so please forgive if this
> is a duplicate. I have a field that I need to change from text to memo to
> allow additional characters. I have gone in under table design and changed
> it to memo, but it will still halt the characters at 255. What am I doing
> wrong?
Re: memo field
John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 03.08.2006 19:02:13
On Thu, 3 Aug 2006 08:26:02 -0700, Dcbrown428
<Dcbrown428[ at ]discussions.microsoft.com> wrote:

[Quoted Text]
>I thought I posted this, but can't find my posting so please forgive if this
>is a duplicate. I have a field that I need to change from text to memo to
>allow additional characters. I have gone in under table design and changed
>it to memo, but it will still halt the characters at 255. What am I doing
>wrong?

I saw the post and replied to it so I'm not sure what's wrong!

Be sure that there is no Format or Input Mask defined for the field;
either will truncate it to 255 characters. Also, don't try to sort by
or group by the field in a query.

John W. Vinson[MVP]
Re: memo field
Dcbrown428 03.08.2006 19:53:01
Thank you for your help!

"John Vinson" wrote:

[Quoted Text]
> On Thu, 3 Aug 2006 08:26:02 -0700, Dcbrown428
> <Dcbrown428[ at ]discussions.microsoft.com> wrote:
>
> >I thought I posted this, but can't find my posting so please forgive if this
> >is a duplicate. I have a field that I need to change from text to memo to
> >allow additional characters. I have gone in under table design and changed
> >it to memo, but it will still halt the characters at 255. What am I doing
> >wrong?
>
> I saw the post and replied to it so I'm not sure what's wrong!
>
> Be sure that there is no Format or Input Mask defined for the field;
> either will truncate it to 255 characters. Also, don't try to sort by
> or group by the field in a query.
>
> John W. Vinson[MVP]
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net