Results 1 to 4 of 4
  1. #1
    DaveShmave
    Guest

    Hide a field in a report... (Access 2000 SR-2)

    I just did a search for what I'm trying to do but haven't had any luck.

    I have a text field in a report (Access 2000 SR-2) that contains numeric and alpha information. Let's call the field "Code". Any valid "Code" starts with a numeric value, however, invalid codes start with an alpha character.

    What I want to do is simply make the field null anytime one of the codes starts with an alpha character. You see, I don't want to eliminate that record or the rest of the data for that record from the report, just hide the invalid codes.

    How can I do this in the Detail_Format section (or wherever) of the form? Or am I better using an IIF statement in the text field (control) on this report?

    TIA

    Dave <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Hide a field in a report... (Access 2000 SR-2)

    >>How can I do this in the Detail_Format section (or wherever) of the form? Or am I better using an IIF statement in the text field (control) on this report?<<

    Probably won't better, but it is easy to do in Detail_format section. Assuming the control is called txtCode:

    txtCode.visible= isNumeric(Left(txtcode),1)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide a field in a report... (Access 2000 SR-2)

    Just an of the cuff comment with no research of experience to back it up.

    What about covering the item with a box which is transparent or opaque, depending if the condition is met?

  4. #4
    DaveShmave
    Guest

    Re: Hide a field in a report... (Access 2000 SR-2)

    Thanks Mark and Rupert!

    I'll look into both of your suggestions.

    Dave <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

Posting Permissions

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