Using Memo-type field with SQL back-end

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.
 
R

Rod Scoullar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
Page numbering with Merged Document and IF statements 1
Restoring line breaks in memo field 2
Need long text field is Access with SQL backend 6
Finding Field Type and Length in a SQL Database 3
Why does my MEMO field truncate my text? 3
Can't get text box on report to display all of text. 3
Memo data type field 1

Top