|
| 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 |
|
#11
February 26th, 2007, 05:23 PM
posted to microsoft.public.access
|
|||
|
|||
memo field size
Thanks. I took it out. The caps were there because sometimes the person who
enters it randomly adds caps. Sometimes you have to work around people. I don't know why ACCESS help or books that I have doesn't mention this annoyance. But it is something that I will not forget. Thanks for the quick response. "John W. Vinson" wrote: On Mon, 26 Feb 2007 08:00:08 -0800, MikeSweet wrote: So even if I specify a "" symbol for the format in the table? Yes, absolutely. Why you would want a memo field in all caps is a mystery to me. Memos are usually used for long narrative text, which is much harder to read in all caps. John W. Vinson [MVP] 
|
|
#12
June 19th, 2008, 09:41 PM
posted to microsoft.public.access
|
|||
|
|||
|
memo field size
Thanks for this reply!
New to Access and this fixed my problem; the format for both the form and the table was set to "@". I still haven't figured out what that is for but removing it allows my field more than 255. Thanks again! "John W. Vinson" wrote: On Mon, 26 Feb 2007 08:00:08 -0800, MikeSweet wrote: So even if I specify a "" symbol for the format in the table? Yes, absolutely. Why you would want a memo field in all caps is a mystery to me. Memos are usually used for long narrative text, which is much harder to read in all caps. John W. Vinson [MVP]
|
|
#13
May 20th, 2010, 05:09 PM
posted to microsoft.public.access
|
|||
|
|||
|
memo field size
Thank you. This solved my problem too. Thanks.
"MSACSNewb" wrote: Thanks for this reply! New to Access and this fixed my problem; the format for both the form and the table was set to "@". I still haven't figured out what that is for but removing it allows my field more than 255. Thanks again! "John W. Vinson" wrote: On Mon, 26 Feb 2007 08:00:08 -0800, MikeSweet wrote: So even if I specify a "" symbol for the format in the table? Yes, absolutely. Why you would want a memo field in all caps is a mystery to me. Memos are usually used for long narrative text, which is much harder to read in all caps. John W. Vinson [MVP]
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Please Help! A2K memo field shows eror "Too much text to edit" | Lauren Wilson | Using Forms | 1 | August 12th, 2004 04:02 AM |
| Text field Or Memo Field | Terry | General Discussion | 2 | August 5th, 2004 04:32 AM |
| Memo Field data truncated in query | Joel | Running & Setting Up Queries | 3 | August 4th, 2004 03:40 PM |
| How to use a teble with a memo field | Steve | General Discussion | 1 | June 23rd, 2004 02:30 AM |
| NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Linear Mode
