Report signatures

  • Thread starter Thread starter AlwaysLearning
  • Start date Start date
A

AlwaysLearning

I have a letter (report) being created based on a query. I want to be able
to sign the letter with the signature of the rep sending the letter. The
query has a text field containing the pathname/filename of the image I want
to insert into the letter. I have created a bound object in the letter and
specify the control source as the field in the query containing the image
pathname/filename. Everything in the letter prints as expected except the
signature.

The query can return multiple records each, possibly, with a different rep's
name. What needs to be done to get this signature to print?

Thanks in advance for your help.
 
Enter a string into the class property of the bound object frame
as follows:

If the signature is a bmp file, enter into the Class property:
Paint.Picture

If the signature has a different file name extension, you may
need to enter a different string, e.g:
Microsoft Photo Editor 3.0 Photo

If these strings don't work for you, follow these steps:
1. Copy a signature to the Windows clipboard.
2. Open the report in design view.
3. Paste the image.
(Access will create an unbound object frame.)
4. Open the properties of the unbound object frame.
5. Copy the Class property of the unbound object frame.
6. Paste into the Class property of the bound object frame.
7. Delete the unbound object frame.

Geoff

PS: I think this newsgroup is for questions about programming
DAO with VBA.



in message
news:D[email protected]...
 
Back
Top