Share via

How can I add space between words when typing in sql view of access?

Anonymous
2025-05-03T16:04:09+00:00

I was using Access 2007 version 2016 file format.

When I tried to type the SQL command in the sql view of query view, I cannot type any spaces. The words are packed together without spacing. How can I solve it?

Just like the picture below www help!!!

Microsoft 365 and Office | Access | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-05-03T16:18:42+00:00

    Perhaps if you showed us a screenshot, or an example of your SQL Statement it might help us understand the issue.

    Have you tried an Office Repair?

    Have you tried updating or rolling back your Office build?
    Have you tried creating the SQL Statement in say Notepad and Copy/Pasting it into Access to see what occurs?

    0 comments
  2. Duane Hookom 26,280 Reputation points Volunteer Moderator
    2025-05-04T03:04:15+00:00

    I’ve seen similar issues while writing VBA code while a form with a timer event is open. Does this happen in all queries and all Access files?

    0 comments
  3. Anonymous
    2025-05-04T10:12:42+00:00

    Great idea Duane! I too have experienced that, but never thought of that as the cause of this issue. Great catch.

    So the question then becomes ... When this issue occurs are all other objects (even hidden ones) closed? If no, try closing them first and try again to see if that is the issue.

    0 comments