littlehelp
MIS
I setup a text field as MEMO, it should be able to enter text more than 255, right? But when reopen the DB, it cutoff the rest of text, only 255 left? What's wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's the MAX character a text field can have?
- Thread starter littlehelp
- Start date
- Status
Check and see if there is some sort of format set on that text field that might be limiting the data. I had a memo field that had the format of short date, how it got there I have no idea, which cut my data off. After I cleared the format property, my data came back. If that doesn't help, then check and see if there is a set value in the text field's property indicating 255.
If you're looking at this in a datasheet, the column width can be set no wider than 255.
Can you place this field on a form and see all of it?
Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
Can you place this field on a form and see all of it?
Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
- Status
Similar threads
