Hello,
The boss wants to be able to write text and design it as he wishes (bold/colors/different fonts/different sizes/etc). I handled that as follows, every time he wants to write text i create a word document, it's saved and can be viewed at anytime. The problem is, i later have to display this text on a report, and the text has to keep its original design. How in the world can i do that? Any help would be greatly appreciated.
Maybe there is a different approach, without creating word files.. any ideas will be welcomed.
8 1428 Not as far as I know, but you can save the word document as attachment in access. Then, you will be able to have it (attachment) displayed on a report. Another way is to save it as image (template) and save the image as attachment to the record. This way, you will be able to display the text directly on the report (I don't think it would take much space as it is only text).
Hope this helps,
Regards,
Ali
Hi Ali, thanks for replying. Can you please specify what do you mean by saving the word document as attachment in access?
You are welcome. I see you are new to access. Please find what I meant in the attached database,
Regards,
Ali
Well i wouldn't say i'm completely new. Anyway i can't open your attachment, i'm using access 2003, so if you save it as such and post again i'll appreciate it.
I am very sorry. I said so because I thought you are using Access 2007 and with it you can create attachment field like any other one.
Regards,
Ali
Both ways for with / without using word document as template do exist, of course if you want to start out without the template would be easier for you.
For without word document, you can create your own report, by using the report wizard would be a good start, from there you will first select the source of the report. When its finished, you can then edit the styling of the report heading, body, etc.. For how to create report CLICK HERE, another good reference.
For using word document as template, honestly I didn't use this method before, but I found and tried the files included from this reference and it works, so you can have a look and see do you need any changes in the 2003 version.
Access 2007 has built in support for rich text. That said, I still prefer development in Access 2003, in part because the help files in Access 2007 are horrible!
Hi, thank you all for responding and sorry i'm so late with my reply, i've been handling some other issues and now coming back to this.
For now i'm trying to copy data from that word file i talked about into excel file, this way the report will be built in excel and it's ok, but still the same problem - how do i copy text from word into excel and keep its format/style unchanged? Maybe PasteSpecial does the job, but i don't really know how to use it. If someone knows please advise me on this
Sign in to post your reply or Sign up for a free account.
Similar topics
by: David Thomas |
last post by:
Hi there, a while ago, I posted a question regarding reading japanese
text from a text file.
Well, since I solved the problem, I thought I'd post my solution for
the benefit of other people with...
|
by: hoke |
last post by:
I want to display plain text files in the browser. The files contain html and javascript and have a .txt extension.
This works fine with files with just html. Unfortunately when showing files with...
|
by: Paul Tomlinson |
last post by:
Tabpages and Imagelists - I want to align the image to the left so I can
display some text...
All, I have a number of tabpages and on each tab page I currently have an
image and some text, now...
|
by: tfs |
last post by:
I have a dropdownlist:
<asp:dropdownlist id="recurrance" runat="server">
<asp:listitem value="0" >None</asp:listitem>
<asp:listitem value="1" >Daily</asp:listitem>
<asp:listitem value="2"...
|
by: Tigrou |
last post by:
Hello,
In a Oracle Database i have text who are stored, this text are in RTF
format, you can see an example below:
{\rtf1\ansi\ansicpg1252\deff0\deflang1036{\fonttbl{\f0\froman\fcharset0...
|
by: Doots |
last post by:
Hello,
Since 2 months i'm looking for a solution for display rtf text in an aspx
page. The only component who can do it is RichTextBox but it's too expensive.
Then if anyone know a solution for...
|
by: Tracey |
last post by:
Hi, there
My application requires to display multiline text in the
cell of datagrid. I set the preferredheight of datagrid's
tablsstyle, however, it is fixed. For text longer than
that, the rest...
|
by: jiayanxiang |
last post by:
Is there any sample code to use Javascript to load and display a text
file?
It will be best if the user can select files using some kind of
explorer. If that's complex, a text box to specify the...
|
by: sukumaster |
last post by:
I can display full table in a griedview
but how can i display only somecolumns in a table
and how to display some text for an instanace 'Itemmaster' in a datagrid
|
by: praveenkumark |
last post by:
Hi,
when i click a link, i am calling a html page. In that page, it will load the data from database(MS-Access). So if the records are more it is taking time to load. So better i want ot...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |