I've got a report in Access with an underlying query that includes the following:
IIf(IsNull(A.Description),B.ProjectName+" "+B.Description,A.Description+" "+(IIf(IsNull(A.Notes),"",A.Notes))) AS BigDescription
The result, BigDescription, is then displayed in a Text Field on the report.
Here's the problem. Three years ago, the Text Field displayed the entire contents of BigDescription; but today, the Text Field cuts off after 255 characters.
Please note that the report was created in Access 2003 (or earlier), and we have upgraded to Access 2007 in the last couple of years. (Yes, we're way behind.) HOWEVER... if, using Access 2007, I open a backup of the database from three years ago, the Text Field on the report still displays MORE than 255 characters; but if I open our current working copy of the database, the Text Field is cutting off at 255.
If this problem was just related to 2007, then I would've expected the old backup version to also show truncation in the Text Field when opened with 2007, but it doesn't. So I'm mystified.
There have been no changes to the relevant fields in tables A or B, and no changes to the query syntax. Nor can I detect any difference in the Text Field properties between the backup copy of the database and today's working copy.