Re: Hide check box if another field is blank
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
On Tue, 9 Jan 2007 08:05:01 -0800, Michelle wrote:
I would like to hid a check box if another field is blank. For example I
have a field Called Released Date if it is blank then i do not want the
Released Check box to show on the report.
Me![ReleasedCheckBox].Visible = Not IsNull([ReleasedDate]
Place the above code in the Format Event of whatever section
[ReleasedCheckBox] is in.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
Relevant Pages
- Re: I need help
... I have an age report that has to tell me which computer is ready to be ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ... If you wish to have a query tell you to replace the computers, ... (microsoft.public.access.queries) - Re: I need help
... I have an age report that has to tell me which computer is ready to be ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ... If you wish to have a query tell you to replace the computers, ... (microsoft.public.access.queries) - Re: Expression Not or Not Like
... In VBA on a form or in a report? ... and there should be no reason for us to guess. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ... (comp.databases.ms-access) - Re: Print Report for current Invoice Number
... My problem is I don't know how to tell the report ... to print for the current record's invoice number. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ... (microsoft.public.access.reports) - Re: Configurate a Check box function
... "fredg" wrote: ... if the Check box is checked, it preview a report, if not ir print. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ... (microsoft.public.access.forms) |
|