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
|
|||
|
|||
My Memo fields only accept 255 characters - Why - they are memo f.
I have a memo field in a database, and when I add more than 255 characters
they go in and soon as I do something else the characters over 255 disappear from the field. The first 255 stay there but the rest are gone. Is there an explanation for this please? Regards Cam Edge |
#2
|
|||
|
|||
Do you have a value in the Format property of the text box?
-- Duane Hookom MS Access MVP "Cam Edge" Cam wrote in message ... I have a memo field in a database, and when I add more than 255 characters they go in and soon as I do something else the characters over 255 disappear from the field. The first 255 stay there but the rest are gone. Is there an explanation for this please? Regards Cam Edge |
#3
|
|||
|
|||
Yes it has the for all caps in it.
Cam "Duane Hookom" wrote: Do you have a value in the Format property of the text box? -- Duane Hookom MS Access MVP "Cam Edge" Cam wrote in message ... I have a memo field in a database, and when I add more than 255 characters they go in and soon as I do something else the characters over 255 disappear from the field. The first 255 stay there but the rest are gone. Is there an explanation for this please? Regards Cam Edge |
#4
|
|||
|
|||
Remove it. Formats will not allow displaying more than 255 characters.
Besides ALL CAPS IS SO DIFFICULT TO READ! -- Duane Hookom MS Access MVP "Cam Edge" wrote in message ... Yes it has the for all caps in it. Cam "Duane Hookom" wrote: Do you have a value in the Format property of the text box? -- Duane Hookom MS Access MVP "Cam Edge" Cam wrote in message ... I have a memo field in a database, and when I add more than 255 characters they go in and soon as I do something else the characters over 255 disappear from the field. The first 255 stay there but the rest are gone. Is there an explanation for this please? Regards Cam Edge |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
BUG: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters | [SolarAngel] | Running & Setting Up Queries | 5 | December 7th, 2004 06:29 PM |
UNION Query truncating Memo fields | Matthew DeAngelis | Running & Setting Up Queries | 4 | June 10th, 2004 02:17 PM |
Memo fields in queries | L Wick | Running & Setting Up Queries | 0 | June 10th, 2004 02:28 AM |
Mail merge involving memo field over 255 characters | Brian | Mailmerge | 3 | May 23rd, 2004 09:53 AM |