All queries work correctly, but all reports are displaying just a portion of the first name. all reports!

any ideas would be greatly appreciated

Is the Control wide enough??

Is there some event on the firstname control?

If the query result shows a full name and this query is the report record source and given no other issues, then you would expect the report to show the same data the query does.

Have you tried to create a report from the query using the wizard and see if the name is showing properly.

Bill,

I will check and respond asap. This program had been generating reports effectively for 18 months and then--WHAM!

appreciate your responding

FYI: It might also be that the Can Shrink property of the textbox is set to YES.