text in Memo field truncated in Datasheet view

  • Thread starter Thread starter yenny
  • Start date Start date
Y

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?
 
yenny said:
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?
Click to expand...

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
 
Back
Top