Weird symbols in a Long Text field on a form

[Faoineag]

Good morning,
suddenly for some days in a field of type Long Text, in Mask mode, strange symbols appear. If, on the other hand, I open the reference table, the text is written correctly. How can I solve this problem?

 

[Minty]

What's "Mask Mode" ?

You can get display corruption if you try and perform any aggregation on Long Text fields.

 

[NauticalGent]

What's "Mask Mode" ?

I think the OP means input mask, which I thought was not allowed on Long Text/Memo fields.

 

[CJ_London]

Really need to know more about what you are actually doing and show an example otherwise just pure speculation.

Also used to be a bug if a long text field is concatenated but not sure if that have been resolved

 

[Faoineag]

I realized that the problem is already present in the query on which the form is based; is a query with Grouping, if I remove this function everything goes back to normal, that is, the strange characters disappear

 

[CJ_London]

see this link - if you need the field, it may be that first will do the trick for you

Microsoft Access Flaws - Grouping by Memo field yields garbage

Describes a bug in Microsoft Access, where a memo field is displayed as garbage in a query that joins on an unindexed field and groups by the memo.

www.allenbrowne.com

 

[Faoineag]

see this link - if you need the field, it may be that first will do the trick for you

Microsoft Access Flaws - Grouping by Memo field yields garbage

Describes a bug in Microsoft Access, where a memo field is displayed as garbage in a query that joins on an unindexed field and groups by the memo.

www.allenbrowne.com

Thank you. Yes, my problem is precisely the one covered in the article. If I insert "First" instead of "Grouping" to the two fields with Memo Text, I resolve in the query, while instead in the form on which the query is based, the words "#Name?"

 

[CJ_London]

#Name means it cannot find a field of that name which implies you have changed it - it is now probably called something like FirstOfmyField

 

[Faoineag]

Thank you! In the form I changed the "Control Source" associating it to "PrimoDiMioCampo" and everything works perfectly. Thanks again