Steve McGuinness
asked on
Format text with multiple fonts in same field
I have an official forms to complete but I have to complete it for several hundred people.
The data is all in an access database .
The source document is in PDF but I have successfully converted to word and slightly less successfully to Excel. On conversion not all fields are editable in word and I really want to be able to see the data on a form in Access where all the other data sits. The conversion to Excel does not maintain the layout in anyway. In a perfect world the output would be editable word for certain user fields and the source document for the actual form but for now I am assuming I will just print an access report.
The source form is heavily formatted. There are several fonts and different sizes, in the middle of sentences certain words are underlined or italisised.
I looked at the article:
https://www.experts-exchange.com/questions/27501076/Can-I-have-multiple-fonts-within-a-concatenated-textbox-on-an-Access-Report.html
I copied in the code and set up a table with a text field. In the field I put fonttype("abcdef",fl_Arial Bold) & fonttype ("ghi",fl_ArialBold) & fonttype ("jkl",fl_TimesBold)
I tried with and without a leading "=". I changed the format of both the table and form to rich text but I dont get evaluated formatted text in my text box
I need to do font size as well as font name/Bold but so the FontType function would need to take 5 paramaters
Fonttype(Text, Font, FontSize, Bold, Italics)
My idea was then to have a table
FormField ID
TextToUse
Typeface
Bold - boolean field
Italics - boolean field
then to have a function that works through all of items with the same FormFieldD to concatonate a formatted piece of text
Does anyone see why the present code does not work or have any ideas how to achieve the solution?
The data is all in an access database .
The source document is in PDF but I have successfully converted to word and slightly less successfully to Excel. On conversion not all fields are editable in word and I really want to be able to see the data on a form in Access where all the other data sits. The conversion to Excel does not maintain the layout in anyway. In a perfect world the output would be editable word for certain user fields and the source document for the actual form but for now I am assuming I will just print an access report.
The source form is heavily formatted. There are several fonts and different sizes, in the middle of sentences certain words are underlined or italisised.
I looked at the article:
https://www.experts-exchange.com/questions/27501076/Can-I-have-multiple-fonts-within-a-concatenated-textbox-on-an-Access-Report.html
I copied in the code and set up a table with a text field. In the field I put fonttype("abcdef",fl_Arial
I tried with and without a leading "=". I changed the format of both the table and form to rich text but I dont get evaluated formatted text in my text box
I need to do font size as well as font name/Bold but so the FontType function would need to take 5 paramaters
Fonttype(Text, Font, FontSize, Bold, Italics)
My idea was then to have a table
FormField ID
TextToUse
Typeface
Bold - boolean field
Italics - boolean field
then to have a function that works through all of items with the same FormFieldD to concatonate a formatted piece of text
Does anyone see why the present code does not work or have any ideas how to achieve the solution?
Have you thought about converting the PDF to RTF? That should let you store font, and other info.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.