none
Random blank spaces inside of words on a report. RRS feed

  • Question

  • First things first: While I do have IT-Knowledge and some basic programming skills I'm absolutely new to Access. I have close to no knowledge.

    My company works with a huge Acces database and they asked me to take a look at a problem which they are not able to solve. I did have a look at it and am close to giving up so you guys are my only hope.

    The problem is that if you open up the print view for a report in access it adds blank spaces (space bar) inside of words so that the text looks something like this:

    "He llo I'm some ran dom generat ed text which has spac es in it whi ch shouldn't be ther e."

    They show in page view and they show on the print out. They however do not show in all the other modes (report view and what not).

    What confuses me the most is that it's not a complicated stiched together text but it's basically one big textfield with a fix text (no variables or anything).

    Any idea? I'm completely lost.

    EDIT: I just gave it one more try and realized that the spaces are not completely random they are reproducable. They for example always happend if there is a w followed by an i "widdow" becomes "w iddow". So I changed the font to check if the error persists and it solved the problem. The font I originally used was Arial 11 and I switched to Calibri 11.

    So I guess I found a work around but still I don't think this should be normal. It's not like Arial is a crazy font.

    • Edited by Raguel Emelrich Saturday, February 10, 2018 4:23 PM additional information
    Saturday, February 10, 2018 4:03 PM

All replies

  • Does this happen if you use another printer?

    Change the computer's default printer and try again.  Do you still have the issue?


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Saturday, February 10, 2018 4:59 PM
  • Check the TextAlign property while in design view. It should NOT be set to "Distribute".

    -Tom. Microsoft Access MVP

    Saturday, February 10, 2018 6:06 PM
  • Hi Raguel Emelrich,

    You had mentioned that,"The problem is that if you open up the print view for a report in access it adds blank spaces (space bar) inside of words, What confuses me the most is that it's not a complicated stiched together text but it's basically one big textfield with a fix text (no variables or anything)."

    I try to make a test on my side.

    Private Sub Report_Load()
    Text1.Value = "Hello I'm some random generated text which has spaces in it which shouldn't be there"
    Text1.FontName = "Arial"
    Text1.FontSize = 11
    End Sub
    

    Output:

    You can see that on my side it is displaying correctly.

    Can you confirm, Is this textbox 'Text Format' is Rich Text or Simple Text?

    How did you assign the text to it? Does it come from any query or table or you assign it manually?

    Did you set any property of Textbox?

    Does issue persist if you create a new form with just one textbox?

    If yes, What if you create a new database for testing purpose and try to produce the same issue. Does issue persist?

    Which version of Access you are using?

    Please try to provide your testing result with above scenarios.

    It will help us to narrow down the issue.

    If possible for you then you can try to post a sample database that can reproduce the issue.

    We will try to make a test with it and try to solve the issue.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, February 12, 2018 6:54 AM
    Moderator