Using Memo-type field with SQL back-end

  • Thread starter Thread starter Robert Harrison
  • Start date Start date
R

Robert Harrison

I'm frustrated on this one.

I need to have a field that can hold a large amount of text data. The
back-end is SQL server. I've tried various data-types, but I either can't
type more than 256 characters into the field OR if I can, then the field
can't be edited. What do I need to have set up to accomplish this?

If I get that part working. Is there anyway to use RichText in an access
textbox?

Thanks for any help.
 
Robert,

The varchar data type in SQL Server can hold up to 8000 characters. When
linked to an Access database this shows as a memo data type. You can also
use the text data type in SQL Server. This has no limit to the number of
characters it can store but I have found it to cause occasional problems
when saving data.

If 8000 characters is sufficient then use varchar. I've used it to save
large amounts of text.

Someone has code which allows rich text in a textbox. I think it is by
Lebans. There is a web site with lots of nifty code but I don't know its
URL.

Rod Scoullar.
 
Back
Top