Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide control or show control depend on field value (Acc2000)

    I can't find the search button for this forum, so here's a question.
    I want to
    1) on a Report, make not-visible a control label if the control is null - but only on the particular record.

    2) On a Form, make visible an unbound label if a separate control has a certain value - again only for the particular record in the detail section of a form.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide control or show control depend on field value (Acc2000)

    Unfortunately, Search had to be disabled until we deal with some server issues.

    The answer to both your questions is VBA code. In a form, the situation is constrained by where the label is - header, footer or detail - and whether the form is continuous or single.

    In a report, you would need to use a detached label and the format event of the detail section. Alternatively, use a textbox and make it's controlsource set it to null if the other control (or the field behind it) meets the condition. The specific way to do that depends on whether the other control is being tested for Null or for a specific value, but it would involve either an IIF statement or an Nz function.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •