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)