textbox maximum character limitation -workarounds

[Guest]

Hello

I wonder if anyone can help.

I need my users to post comments via my form into my database, however there
appears to be a restriction on the number of characters that can be added to
the cell in my table.

Is there a way around this at all?

Any comments would be most welcome

Much appreciated


Nick

 

[Pieter Wijnen]

you need a memo field to be able to input more than 255 chars

Pieter

 

[John W. Vinson]

there
appears to be a restriction on the number of characters that can be added to
the cell in my table.

There are no "cells" in tables - that's for prisons, and for Excel
spreadsheets. There are fields, however.

A Text field is limited to 255 characters. Open the table in design view (not
the form but the table); select this field; and change its datatype to Memo.
Be sure there is nothing in the field's Format property (or you'll be back to
255); otherwise this will let you type 65536 characters.

John W. Vinson [MVP]

 

[Brent Spaulding \(datAdrenaline\)]

In addition to John's response ... the 64k limit is the text box limit,
however, you can append WAY more text to a memo via code. You are only
limited by the size of you database.