How to Increase Memo Length

[Mahendra1000]

Hello,

I have created a table in which there is one column of type memo. When I copy the content in this column it is allowing me to enter only 255 characters. How to increase the length of this column type memo?

I have a query with GroupBy. Is it causing me the damage? How to oversome this situation.



Need your valuable suggestions on this.

[Dal Jeanis]

I'm not sure why you would "group by" a memo field. Are there many duplicates of the same memo?

If you are just including the memo in the Group By in order to get it to show up in the results, consider leaving it out of the Group By and using First(MyMemo) instead.

If not, please post the SQl from the query so we can see what you are doing.

[Mahendra1000]

I used the below query

SELECT Main.Authors, Main.Title, Main.Language, Main.Pages, Main.Location, Main.[Contributed Authors], Main.Keywords, Main.Email, Main.University, Main.Published, Main.Abstract
FROM Main
WHERE (((Main.Authors) Like "*" & [Forms]![MForm]![Authors] & "*") AND ((Main.Title) Like "*" & [Forms]![MForm]![Title] & "*") AND ((Main.Language) Like "*" & [Forms]![MForm]![Language] & "*") AND ((Main.Pages) Like "*" & [Forms]![MForm]![nPages] & "*"))
GROUP BY Main.Authors, Main.Title, Main.Language, Main.Pages, Main.Location, Main.[Contributed Authors], Main.Keywords, Main.Email, Main.University, Main.Published, Main.Abstract
HAVING (((Main.Location) Like "*" & [Forms]![MForm]![Location] & "*") AND ((Main.[Contributed Authors]) Like "*" & [Forms]![MForm]![Contributed] & "*") AND ((Main.Keywords) Like "*" & [Forms]![MForm]![Keywords] & "*") AND ((Main.Email) Like "*" & [Forms]![MForm]![Email] & "*") AND ((Main.University) Like "*" & [Forms]![MForm]![University] & "*") AND ((Main.Published) Between Nz([Forms]![MForm]![start],1700) And Nz([Forms]![MForm]![end],3000)) AND ((Main.Abstract) Like "*" & [Forms]![MForm]![Abstract] & "*"));

Abstract field is the memo in my table.

I used groupby for the read only permissions. The results displayed by the search button are having write and read permissions too. I don't want the users to have write permissions. So, I used groupby function for granting read only permissions.

[RuralGuy]

PMFJI but this link might help: http://allenbrowne.com/ser-63.html

[Mahendra1000]

PMFJI but this link might help: http://allenbrowne.com/ser-63.html

Thanks RuralGuy,

It worked. I used First instead of GroupBy. Now my memo field seems perfect.

[RuralGuy]

Excellent! Glad we could help.