469,086 Members | 1,182 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,086 developers. It's quick & easy.

Adding a Watermark

1
I have a form that has a drop down box which has a list of different reports created in access.

On the form i need to add a tick box, which allows the user the option to print a watermark on the report they decide to open.

I have created a bitmap image for my watermark.

Anyone any ideas of the code i would use within the form and the reports to add the watermark when the option has been ticked?
Aug 11 '10 #1
2 6902
first make the image a gif with trabsparent background...

then in front of said form, add a imagebox preferabbly called image frame

and set the value of picture to none

in the code try
Expand|Select|Wrap|Line Numbers
  1.  
  2. Private Sub Detail_Format
  3. Dim strImagePath As String 
  4.  
  5. if (Watermarked condition) then
  6.         strImagePath = <Path for image>
  7.         Me.ImageFrame.Picture = strImagePath 
  8. end if
  9.  
hopee this works
Aug 13 '10 #2
ADezii
8,800 Expert 8TB
You can Embed the Bitmap Image on the Report then set its Visible Property to False. Place code in the Open() Event ot the Report which then checks the State of your Check Box on the Form, then sets the Visibility of the Image accordingly, as in:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_Open(Cancel As Integer)
  2.   Me![Image18].Visible = Forms!Form1![chkWaterMark]
  3. End Sub
Aug 13 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Erik Hendrix | last post: by
1 post views Thread by m3ckon | last post: by
2 posts views Thread by Prashant | last post: by
9 posts views Thread by Chuck Anderson | last post: by
reply views Thread by =?Utf-8?B?S2Vycnk=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.