Code to toggle form picture off and on

[mshields]

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

 

[Perry]

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

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?

 

[Damon Heron]

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

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?