|
| 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
December 31st, 2004, 08:01 PM
|
|||
|
|||
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
December 31st, 2004, 08:51 PM
|
|||
|
|||
|
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
December 31st, 2004, 09:21 PM
|
|||
|
|||
|
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
December 31st, 2004, 10:13 PM
|
|||
|
|||
|
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 |
Linear Mode
