I'm using Access 2007 and need to extend the 255 character limit in a form I have. I have the cell this text box references marked as a memo already and have changed the text box properties to say "Yes" to Can Grow, but the text box is still limiting at 250 characters. I've looked in print preview to see if it maybe would print ok, but the text is still cut off. Is there a way to fix this without editing the text of all of my fields?
Text Box Character Limits
- Thread starter kastoney
- Start date
missinglinq
AWF VIP
- Local time
- Yesterday, 22:55
- Joined
- Jun 20, 2003
- Messages
- 6,420
You have to be dealing with a Query here and Queries do, under certain circumstances, truncate the data in Memo Fields.
Have a look at llen Browne's "Truncation of Memo fields" for an explanation and workarounds:
http://allenbrowne.com/ser-63.html
Linq ;0)>
Have a look at llen Browne's "Truncation of Memo fields" for an explanation and workarounds:
http://allenbrowne.com/ser-63.html
Linq ;0)>
boblarson
Smeghead
- Local time
- Yesterday, 19:55
- Joined
- Jan 12, 2001
- Messages
- 32,059
1. Controls on Forms do not work with Can Grow.
2. You need to set the Scroll Bars property of the text box so you can scroll up and down or side to side with it.
3. Make sure the table's field you have is set to memo and not to Text.
4. Is your table an Access table or is it a linked Excel spreadsheet or something else?
Memo fields should work fine in text boxes on forms and give you more than what you've specified. But it would appear that you may not have the correct table settings set or else you also have a particular setting on the text box itself.
2. You need to set the Scroll Bars property of the text box so you can scroll up and down or side to side with it.
3. Make sure the table's field you have is set to memo and not to Text.
4. Is your table an Access table or is it a linked Excel spreadsheet or something else?
Memo fields should work fine in text boxes on forms and give you more than what you've specified. But it would appear that you may not have the correct table settings set or else you also have a particular setting on the text box itself.
