Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Field Values (2000 SR1)

    I am trying to create an address list that will always display First Name and Last Name, but hide the address fields for some records. My overall goal is to be able to print a confidential address list, and a public list. I have created a field called 'Hide Address' with a yes/no datatype. I then created a form and assigned a conditional setvalue macro to the 'Hide Address' field. When the data met my condition it hid all the address fields for every record. Is there a way to isolate individual records?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Hiding Field Values (2000 SR1)

    One way is to do the work in a query.
    Create calculated fields:
    eg ShowTown : iif([Hideaddress]=true,"",[Town])
    The field showTown will be an empty string if HideAddress is true, otherwise it will be the Town field.
    Repeat this for each address field.
    On the public list only include these calculated fields.
    Regards
    John



  3. #3
    New Lounger
    Join Date
    Jul 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Field Values (2000 SR1)

    Thank you! It worked like a charm!!

Posting Permissions

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