I am not sure if this will answer what you are asking, but I will try.
Resuming:
- How can I solve the 255-truncation issue for non table fields but defined in the query (select a, b, c, sfunction(a,b,c) as [Non table field] from source...)?
For your "non-table field", I think you need to make it an actual field. I would use a work table (a local table). Run the query and save the results from the query into the work table. Then export the work table records to Excel. In that way, you would have your field. I'm sure there are other ways to do it, but this is a quick (possible) solution. - How can I change the format of query fields, both direct from tables -if needed- and defined in query?
I think here you are referring to the other article and maybe the directions in that other article were not very clear. The other article talked about the @ symbol in the description field (of the table or query).
You said:
"I can handle the @ at fields on table definition buy I don't get where can I do that on query fields, even I checked all of its properties."
So, I'm assuming you want more specific instructions on how to find that.- Open the query in Design view.
- Open the Property Sheet (on the Query Design menu, one of the last toggle buttons in the ribbon / tool bar)
- Among the list of fields down below in the query grid, click on the Memo field that is being considered (put the cursor on its name). When you do this, the Property Sheet changes to the properties for this specific Memo field. One of the properties is the description field (the first one). For me, it is always blank, but for some people, apparently there is an @ symbol.