• hiding a control (A2K SR1)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » hiding a control (A2K SR1)

    • This topic has 4 replies, 2 voices, and was last updated 24 years ago.
    Author
    Topic
    Gwb
    AskWoody Lounger
    June 27, 2001 at 8:27 pm #357470

    I have a report with fields like QuanO, QuanD, SKU, Desc, Price. In the detail section the SKU field is directly under the Desc field so that it always displays the item number under the description. However, if we type comments on the order, the item number becomes REM and the description then is the typed-in comment. The following is the data source for the SKU field: “=IIf([sku]=”REM”,” “,[SKU])” That blanks out the REM from showing, but it leaves a blank line where the SKU control is. What I would like to do is to shrink the detail section to 1 line when the SKU=REM. Can I do that through code, or is there a better way? Any ideas?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WScharlotte
      AskWoody Lounger
      June 27, 2001 at 11:16 pm #531118

      The simplest way to deal with it, assuming that nothing else is on the same line with the SKU field, is to set the SKU field to something approximating a zero height. Then set the CanGrow property of both the control and the section to True. Move the other controls up close beneath the SKU control. Then change your formula to “=IIf([sku]=”REM”,Null,[SKU])”.

      The result will be that the row will appear when you have an SKU and disappear when you don’t. The SKU field will expand to display data and will push the rows below it down but will not do so when the value is null.

      Reply | Quote
      • Gwb
        AskWoody Lounger
        June 28, 2001 at 11:51 am #531167

        Charlotte–thanks, that works, but I have vertical lines in that detail section to create columns. I made the vertical lines the same height as the detail section, but when it grows, the lines don’t so they become dashed lines. Can I make a function to set the line height? iif([sku]=”REM”,null,funSetLine) Or is there a better way?

        Reply | Quote
        • WScharlotte
          AskWoody Lounger
          June 28, 2001 at 12:22 pm #531173

          I did warn you about other controls on the same line being pushed down, didn’t I? Do your line lengths depend on section height or did you just size them in at a fixed height for each row? You can download a sample reports database RptSmp00.exe from Microsoft which contains a report showing lines drawn from code on a report. That might help you.

          Reply | Quote
          • Gwb
            AskWoody Lounger
            June 28, 2001 at 1:02 pm #531183

            Thanks again Charlotte. I got it to work by using code from the sample database.

            Reply | Quote
    Viewing 0 reply threads
    Reply To: hiding a control (A2K SR1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.