Data Truncating in Text Field

  • Thread starter Thread starter gwmurray
  • Start date Start date
G

gwmurray

I have several data fields on a medical dbase i'm putting together. Some
of these fields will need to be in excess of 500 characters long. For
some reason the text boxes that I currently have on my form will only
go to about 50 characters and won't go any further.

How can I make it unlimited or at least a very high numbered character
so that someone can put something as long as a medical diagnosis in the
text box??

Thanks!
 
A text box should be able to hold many many characters, but a text field
in the db is limited to 255. Perhaps your textbox is bound to a text
field with a size of 50.

You can use Memo fields to eliminate the 255 limit, but I recall
reading that they are stored apart from the record in the database and
notoriously corruptable. If you need say 500 char you might consider
textField1 and textField2?

hth
aaron
 
Back
Top