text in Memo field truncated in Datasheet view

[yenny]

I pasted a chunk of html codes into a memo field (in
Datasheet view), but as soon as I move the cursor to the
next record, the text that I just entered was truncated.
There is no error messages at all. So, how do I know that
the record was fully pasted or not? How to view the whole
text in Datasheet view?

 

[Arvin Meyer]

I pasted a chunk of html codes into a memo field (in
Datasheet view), but as soon as I move the cursor to the
next record, the text that I just entered was truncated.
There is no error messages at all. So, how do I know that
the record was fully pasted or not? How to view the whole
text in Datasheet view?

Make sure the underlying field is a memo field, not text. Click (set focus)
in the textbox and press SHIFT+F2. a zoom box will open and allow you to
scroll the contents. A memo field can accept up to 64 K from the UI and up
to 2 GB from code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access