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?
10  2977  twinnyfo 3,653
Recognized Expert Moderator Specialist
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....
twinnyfo 3,653
Recognized Expert Moderator Specialist
Also, could you possibly include picture of what is happening?
hi twinnyfo, the header controls are labels and the question marks only show up in the pdf version.
twinnyfo 3,653
Recognized Expert Moderator Specialist
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.
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.
Should I try using a text box instead of a label as the header control?
oops, I just realize that a textbox will not work as it will be unbound.
twinnyfo 3,653
Recognized Expert Moderator Specialist
You can use a text box, but the ControlSource will then be:
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.
twinnyfo 3,653
Recognized Expert Moderator Specialist
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.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: mary |
last post by:
When I read an HTML file starting with
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
and then I write it into another file, say OUTPUT.txt, I get an
inverted question mark, "¿",
at the beginning of the OUTPUT.txt file. Why is that?
Thanks!
mary
|
by: Mad Scientist Jr |
last post by:
I am having a hard time figuring out how to set header text for a
datagrid - I have found a number of pages on it but none work. Some
seem to be for vb.net desktop applications not web.
Can someone help? Below is my code, I want to set the header text to:
"My<br>Header<br>One" for MyField1
"My<br>Header<br>Two" for MyField2...
|
by: saad82 |
last post by:
I want to be able to replace a single line in a large text file
(several hundred MB). Using the cookbook's method (below) works but I
think the replace fxn chokes on such a large chunk of text. For now, I
simply want to replace the 1st line (CSV header) in the file but I'd
also like to know a more general solution for any line in the file....
|
by: Agent Michael Scarn |
last post by:
Hello All,
After I submit a form it goes to a post page where I have a javascript
that creates one variable that has all of the element names from the
form listed out like so:
var1=var1&var2=var2&var3=var3
and so on...
|
by: fredd00 |
last post by:
hi
i'm trying to change the gridview columns header text
the columns are not auto generated, i have set specific headertext
values for each column
i want to change the header text based on the specific header text. i
want to load a new text from a global resource file.
what i'm actually trying to do and is not working :
| | |
by: maria |
last post by:
I only use C++ with Visual Studio 6.0 for string manipulations in
thousands of HTML pages on my website. Many times, the output files of
many of my C++ programs contain a spanish question mark (¿) as their
first character. What creates it? How do we avoid it?
Thanks!
maria
|
by: vj6940 |
last post by:
hi,
i am writing a program to search first word from a line
but i am not getting an idea to how to do this?
if any one have a solution then mail me <Removed>
thanks !!!!!
|
by: kronus |
last post by:
Hi everyone,
This is my first time posting to the UNIX form and it might be a strange request, but I believe I have most of the pieces.
Here's the overall goal -- I am trying to find the links in a large web site that are linked to files over 2000k.
I used the command line to find all files on the server that are larger than 2000k by...
|
by: whodgson |
last post by:
The following code accepts a string from the user and swaps the first and last letters in each word. It prints out the original string incorrectly by dropping off the first letter of the first word. I would like to establish what error in the code is causing the first word to be mangled.
#include<iostream>
#include<cstring>
#include<cstdlib>...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
