Weird symbols in a Long Text field on a form

Faoineag

Registered User.
Local time
Today, 08:25
Joined
Jan 7, 2018
Messages
99
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?
 
What's "Mask Mode" ?

You can get display corruption if you try and perform any aggregation on Long Text fields.
 
Last edited:
It might be that your text contains hidden characters? To check, Search the internet for "show hidden characters" and you will find a multitude of sites where you can copy and paste your text into them and show these characters.

 
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
 
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
 
see this link - if you need the field, it may be that first will do the trick for you

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?"
 
#Name means it cannot find a field of that name which implies you have changed it - it is now probably called something like FirstOfmyField
 
Thank you! In the form I changed the "Control Source" associating it to "PrimoDiMioCampo" and everything works perfectly. Thanks again
 

Users who are viewing this thread

Back
Top Bottom