Text field seems to limit input too much

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003, APD project, MS SQL backend.

I have a notes field in one of my tables that is represented by a text field
on a form. The field is varchar(100) in the database.

Users have noted that the text field won't let them enter much text, much
less than 100 chars anyway. I don't see anything in the control properties
that would limit this -- or I'm not looking in the right place?

I assume this limit comes from the DB. I _did_ make this field larger in the
DB, it used to be varchar(50) IIRC, so perhaps this is the problem? If so,
how do I get the field to see the new size?

Maury
 
Change the field type in the table properties to a memo field instead of a
text field, then you can enter as much as you want. However, do a search of
this site on memo fields so that you are aware of the problems that they can
cause depending on what you do with the field.
 
Back
Top