I have a report in ms access where I use a query as it's source the problem i'm having is with the memo field being truncated at 255 character.
please note i utilse an expression on the memo field in the query
Rem: Max(IIf(IsNull([Pst_Remarks])=True,[Allow_code],IIf(IsNull([Allow_code])=True,[Pst_Remarks],[Allow_code] & " " & [Pst_Remarks])))
how can i make the report show all character
please note i utilse an expression on the memo field in the query
Rem: Max(IIf(IsNull([Pst_Remarks])=True,[Allow_code],IIf(IsNull([Allow_code])=True,[Pst_Remarks],[Allow_code] & " " & [Pst_Remarks])))
how can i make the report show all character