Code to toggle form picture off and on

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I'm using Access 2003. I created a form and with a background picture, and have entered records into the database. I added a print button.

Now I want to add some code to the print button to toggle the picture off before printing, and on after. Is there an easy way to accomlish this in Access?

Thank you in advance
Marlene
 
what about something like

Dim sPic As String
sPic = Me.Picture
Me.Picture = "" 'turn it off
MsgBox "hold_on_a_sec"
Me.Picture = sPic 'restore picture

Krgrds,
Perry

mshields said:
Hello,

I'm using Access 2003. I created a form and with a background picture,
Click to expand...
and have entered records into the database. I added a print button.
Now I want to add some code to the print button to toggle the picture off
Click to expand...
before printing, and on after. Is there an easy way to accomlish this in
Access?
 
Did I understand you to say you are printing the forms? Why not create a
report, then you won't have to worry about the picture on your form?
Reports are far better than printing forms to create paper records.

HTH
Damon


mshields said:
Hello,

I'm using Access 2003. I created a form and with a background picture,
Click to expand...
and have entered records into the database. I added a print button.
Now I want to add some code to the print button to toggle the picture off
Click to expand...
before printing, and on after. Is there an easy way to accomlish this in
Access?
 
Back
Top