I was trying to format a Memo Box by using >. However whenever I look at my table some of the data is cut off. Is this because if I format a memo box it takes the format of a text box. Thanks :confused:

I am not sure about this but I don't think you can format a memo. Ctrl Enter will allow you to add a carriage return but I think that's about all you can do.

what I mean is that in the table design I can put ">" in the format to make everything in caps. However when I just type a long paragraph in the the table it cuts of some of the data. I was wondering if that because it makes it a text box or not?

Are you saying that you are trying to put an Input Mask on a texbox that is bound to a memo field?

Please give us an example of the data you putting in and what is getting cut-off.

If you are looking at your data in datasheet view, the memo filed will be displayed as one long text field. If your column isn't wide enough to see the whole field, you will only see part of it. Click on your data in that field and hit the End key and it should take you to the end of your field. If you are looking at the data in form view, the memo field will display with scroll bars so you should be able to scroll to see all the data. Memo fields are different than text fields. 255 character limit on text but memo can store up to 64,000 characters.

Sam

65, 535 characters in a memo, to be exact. :p

Example, when you look at the table design and have a memo field and look at the general tab you see a place to put a format, which I put a ">" in there to have everything in there to be in Caps. But when I view the table I notice that some of the data that is long is cut off at some point. So I was wondering if I put something in the format will it become a text box and not show more then 255 characters but be able to type more then that. I hope this makes sense. Thanks

That's interesting.

I just recreated it and I see it happening.

In my memo with the > format it reduces the number of characters to 255.

If I take the format off and add another 200 characters, and then put the format back on, the 200 letters are gone, and then I remove the format which restores the 200 extra characters.

I don't know why this happens and can't offer any solution/suggestion, etc. but as it appears to continue to store the full memo data so I should think your data will be safe.

"65, 535 characters in a memo, to be exact"
not when using vba to fill it it's not:p