Link to home
Start Free TrialLog in
Avatar of Biggles1
Biggles1Flag for United States of America

asked on

Embedding different Fonts and Images in a report

in MSACCESS Report"

I need some phrases to be in different Formats.  Example:

This is plain text This is Italics this is plain text again and this is bold

Also I would like to embed a jpg or bmp in the text, for example a signature (that was captured as jpg or bmp) at the bottom of a letter,

Ideas anyone?  Thanks again.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

You can use a memo field (long Text) and set the text format to RichText (instead of Plain text).  This will allow you to modify the font size and properties within a textbox, and then display the same in your report.

For the bitmap/jpg, you will have to add an image control at the end of the textbox and display that signature in the image control.
Avatar of Bill Prew
Bill Prew

Here's a simple example of the rich text part, mostly to just put Dale's thoughts into a prototype.  Depending on your needs you might approach it slightly differently, but hope this gives you some ideas.

EE29137116.accdb


»bp
Avatar of Biggles1

ASKER

Embedding a .bmp image in a Report

Unfortunately I am using a .mdb file NOT a .accdb file so I have given up on embedding different fonts in a report.

However I still want to embed a .bmp or .jpg..

The report has an underlying table from which the Report text is originating.
I added a OLE Object Field and called it [Signature]
My report now has a field Called [Signature] originating from that table

I captured a signature using the Snipping Tool and stored it as C:\......\Signature.bmp
Question: How do I get the Signature Image to appear in my report?
In the control source of the Bound Object Frame in the report I typed C:\......\Signature.bmp but the report can't find it!

What am I doing wrong?  (Remember this is a .mdb file)
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.