Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

disable checkbox on report

Status
Not open for further replies.

Xiphiaz

Programmer
Dec 29, 2003
33
NL
Hi,

On my form I disable checkboxes true this string:
---------------------------------------------
Private Sub Form_Open(Cancel As Integer)
If Me.Selectievakje273 = True Then
Me.Selectievakje274.Enabled = False
Me.Selectievakje275.Enabled = False
Me.Selectievakje303.Enabled = False
Me.Selectievakje277.Enabled = False


Else

Me.Selectievakje274.Enabled = True
Me.Selectievakje275.Enabled = True
Me.Selectievakje303.Enabled = True
Me.Selectievakje277.Enabled = True
End If
End Sub
--------------------------------
But I also want to be able to keep those boxes enabled if I print the report of this form.

I already tried to put this in the open event, but that gives errors.

So is there anyone who can help me.
What I want is: if I hit the print button on my form, the report fist checks if checkbox273 is true. If so disable the otherones.

Thanx

Xiphias

 
????????? What ARE you thinking ???????????

What possible difference cna there be to wheather a control is enabled or disabled on a REPORT (or even a printed version of a FORM)? HOW would a user 'interact' with the report (i.e. CHANGE the value?





MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Haha ok your right, but what I meen is that I can see on the printed report that those boxes are disabled.
I think that would make my report much easier to read.

haha....you'r so funny...:)
 
You can use a text box rather than a check box. Set the format property to:
Code:
\x;\x;¨[Blue]
and the font to
Wingdings
You may need to copy the format property value directly from this response to your property sheet.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top