The simplest solution would be to open the table in design view, and clear
the Caption property for your fields.
If that doesn't work, you could alias the fields in the query. For example
if you have FirstName showing as First Name (with a space), and you want it
to actually show as FirstName, switch the query to SQL View (View menu), and
change the SQL statement from:
SELECT Table1.FirstName, ...
to:
SELECT Table1.FirstName AS FirstName, ...
