Memo Field Truncated in Access 97.

[bdehning]

When I use the work around for use of a memo field by placing 'First' in
the total row of the query and changing source in report I am able to get
more than 255 characters to display.

When I use the following NonBlankComments: First(IIf(Len(Trim$([Comments]
& ""))=0,"No Comments",[Comments])) in a field and place exprsssion in total
row my field is being truncated. I have been using this to show the words No
Comment when the field is not used.

Can some one help me on this with a work around.

Here is the SQL currently that gives me a good FirstofComments field but a
trunctated NonBlankComments field.

SELECT Location.[Assigned Consultant], Count(Location.[Assigned Consultant])
AS [CountOfAssigned Consultant], [Service Calls].[Service Call Number],
Location.[Account Name], [Service Calls].[Scheduled Service Month], [Service
Calls].[Policy Number], Location.[Location Servicing Division],
Location.[Location Address], Location.[Location City], Location.[Location
State], [Service Calls].[Date of Survey], [Service Calls].[Date Written
Report Sent], First([Service Calls].Comments) AS FirstOfComments, [Service
Calls].[Service Call Type], Count([Service Calls].[Service Call Type]) AS
[CountOfService Call Type], [Original Service Call Month].[Rescheduled
Service Month], [Original Service Call Month].[Original Service Call Date],
[Service Calls].Recommendations, First(IIf(Len(Trim$([Comments] & ""))=0,"No
Comments",[Comments])) AS NonBlankComments
FROM Location INNER JOIN ([Service Calls] INNER JOIN [Original Service Call
Month] ON [Service Calls].[Service Call Number] = [Original Service Call
Month].[Service Call Number]) ON Location.[Location ID] = [Service
Calls].[Location ID]
GROUP BY Location.[Assigned Consultant], [Service Calls].[Service Call
Number], Location.[Account Name], [Service Calls].[Scheduled Service Month],
[Service Calls].[Policy Number], Location.[Location Servicing Division],
Location.[Location Address], Location.[Location City], Location.[Location
State], [Service Calls].[Date of Survey], [Service Calls].[Date Written
Report Sent], [Service Calls].[Service Call Type], [Original Service Call
Month].[Rescheduled Service Month], [Original Service Call Month].[Original
Service Call Date], [Service Calls].Recommendations
HAVING ((([Service Calls].[Date Written Report Sent]) Is Not Null));

Can code be added to fool the nonblankcomments field just like
firstofcomments field?