Question mark beside the first word in each line of a header text in a report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wirejp
    New Member
    • Jun 2014
    • 77

    Question mark beside the first word in each line of a header text in a report

    This is a follow-on post from the link: http://bytes.com/topic/access/answer...-layout-tables
    I am using a Microsoft Access 2010. I have created a report to show the invoice amounts for a client. The report was generated from a query which was built from the Fee Schedule Table.
    I inserted a header and footer in the header section of the report. When I export the report as a pdf document, I noticed that pdf document show a question mark (?) beside the first word on each line of the header text. What is the reason for this and how do to fix the problem?
    Last edited by wirejp; Nov 4 '14, 06:26 PM. Reason: updating query
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3655

    #2
    wirejp,

    Are your header controls labels or text boxes? Does it only show up in PDF or in print preview, too?

    But the rest of the text in the header is correct, it just includes the question mark?

    I'll try to reproduce that situation....

    Comment

    • twinnyfo
      Recognized Expert Moderator Specialist
      • Nov 2011
      • 3655

      #3
      Also, could you possibly include picture of what is happening?

      Comment

      • wirejp
        New Member
        • Jun 2014
        • 77

        #4
        hi twinnyfo, the header controls are labels and the question marks only show up in the pdf version.

        Comment

        • twinnyfo
          Recognized Expert Moderator Specialist
          • Nov 2011
          • 3655

          #5
          Any fancy characters in those labels or just plain ol' text characters? Very strange..... It obviously has to do with the Adobe conversion, but what it could be is a mystery at this point.

          Comment

          • wirejp
            New Member
            • Jun 2014
            • 77

            #6
            there are some special characters such as "c/o" and "@".
            I should have mentioned that I had copied and pasted the text from a Word documents into the header label. Just now, I deleted out the whole text and I manually typed the information. When I exported the report as a pdf document, there were most of the question marks disappeared but there were 4 instances of question marks which are now at the end of the text line.

            Comment

            • wirejp
              New Member
              • Jun 2014
              • 77

              #7
              Should I try using a text box instead of a label as the header control?

              Comment

              • wirejp
                New Member
                • Jun 2014
                • 77

                #8
                oops, I just realize that a textbox will not work as it will be unbound.

                Comment

                • twinnyfo
                  Recognized Expert Moderator Specialist
                  • Nov 2011
                  • 3655

                  #9
                  You can use a text box, but the ControlSource will then be:

                  Code:
                  ="Add Your Text Here"

                  Comment

                  • wirejp
                    New Member
                    • Jun 2014
                    • 77

                    #10
                    Thanks, twinnyfo for the help. Your suggestion in post #9 worked like a charm.

                    I also figured out what was causing the problem: when I was copying and pasting the block of text line (made of 8 lines of text) from the Word document into the header label of the report, at the end of each text line, a section of "empty blank space" was being highlighted and copied & pasted into the header label of the report. This empty blank space was causing Microsoft access not to recognise this empty space. So I only copied and pasted each line of text individually from the Word document into the header label of the report, then the question marks disappeared.
                    Last edited by wirejp; Nov 4 '14, 08:05 PM. Reason: updating comment

                    Comment

                    • twinnyfo
                      Recognized Expert Moderator Specialist
                      • Nov 2011
                      • 3655

                      #11
                      You would be surprised how those special characters get re-interpreted by other applications. I understand why they are there, but it can cause headaches if not managed properly.

                      Glad we could be of service.

                      Comment

                      Working...