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
|
|||
|
|||
MEMO FIELD
I am using a form to enter data into my table. One of the
fields in the table is a memo field. THE PROBLEM IS: When I type in the infromation in the form everything looks good but if I go to the next record or save the current record the memo field only stores about 20 words. I thought the memo field stored something like 60,000 characters (I am no where near this) Any suggesttions? |
#2
|
|||
|
|||
Do you have a format property value set in your form or table?
-- Duane Hookom MS Access MVP "SEAN" wrote in message ... I am using a form to enter data into my table. One of the fields in the table is a memo field. THE PROBLEM IS: When I type in the infromation in the form everything looks good but if I go to the next record or save the current record the memo field only stores about 20 words. I thought the memo field stored something like 60,000 characters (I am no where near this) Any suggesttions? |
#3
|
|||
|
|||
-----Original Message----- Do you have a format property value set in your form or table? -- Duane Hookom MS Access MVP "SEAN" wrote in message ... I am using a form to enter data into my table. One of the fields in the table is a memo field. THE PROBLEM IS: When I type in the infromation in the form everything looks good but if I go to the next record or save the current record the memo field only stores about 20 words. I thought the memo field stored something like 60,000 characters (I am no where near this) Any suggesttions? . the only format I have is "" so everything is in caps. |
#4
|
|||
|
|||
That's your problem. Remove the format. Besides ALL CAPS REALLY IS HARD TO
READ. -- Duane Hookom MS Access MVP "sean" wrote in message ... -----Original Message----- Do you have a format property value set in your form or table? -- Duane Hookom MS Access MVP "SEAN" wrote in message ... I am using a form to enter data into my table. One of the fields in the table is a memo field. THE PROBLEM IS: When I type in the infromation in the form everything looks good but if I go to the next record or save the current record the memo field only stores about 20 words. I thought the memo field stored something like 60,000 characters (I am no where near this) Any suggesttions? . the only format I have is "" so everything is in caps. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pop Up Memo Field, is this possible? | Dave Elliott | Using Forms | 3 | September 3rd, 2004 10:53 PM |
Text field Or Memo Field | Terry | General Discussion | 2 | August 5th, 2004 04:32 AM |
Rich text in memo field | Rob Rutherford | Using Forms | 3 | July 28th, 2004 10:22 PM |
Memo field gets truncated in report | M Skabialka | Setting Up & Running Reports | 5 | June 25th, 2004 04:56 PM |