Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

not print/show field for particular record

Discussion in 'Information Technology' started by Karen, Jul 28, 2006.

  1. Karen

    Karen
    Expand Collapse
    Guest

    Hi,

    I would like to give users the option of not printing/displaying the results
    of a field of particular records (because of the amount of text in these
    fields which is likely not relevant to them).

    I know I could run an update query to mark those records and then have those
    entire records not be displayed. But it would be nice to display those
    records, just not that particular field. Is there a way to hide a field for
    a particular record?

    Thanks for any suggestions.
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Hide it where? In a form, a report?

    Sure, you can set a field's property to visible=false.

    If you want to hide it in a report, you could just leave it out. If you
    want to show it for SOME records, then add a new field to the record (maybe
    a checkbox) called "PrintXxxx" where "Xxxx" is the name of the field. Then,
    include code in your report or form, or use an IIF statement in an unbound
    textbox.

    Lots of ways to do this.

    --
    Rick B



    "Karen" <Karen@discussions.microsoft.com> wrote in message
    news:31D61926-5148-4147-8946-DDA4ACB9E769@microsoft.com...
    > Hi,
    >
    > I would like to give users the option of not printing/displaying the
    > results
    > of a field of particular records (because of the amount of text in these
    > fields which is likely not relevant to them).
    >
    > I know I could run an update query to mark those records and then have
    > those
    > entire records not be displayed. But it would be nice to display those
    > records, just not that particular field. Is there a way to hide a field
    > for
    > a particular record?
    >
    > Thanks for any suggestions.
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 9 May 2006 10:51:01 -0700, Karen wrote:

    > Hi,
    >
    > I would like to give users the option of not printing/displaying the results
    > of a field of particular records (because of the amount of text in these
    > fields which is likely not relevant to them).
    >
    > I know I could run an update query to mark those records and then have those
    > entire records not be displayed. But it would be nice to display those
    > records, just not that particular field. Is there a way to hide a field for
    > a particular record?
    >
    > Thanks for any suggestions.


    Sure.
    Add a CheckBox field to the underlying table.
    Include the Check Box on the form.
    Have the user check which ever records they DON'T want to display that
    field when printed.

    Include the check mark field in the report's record source as well as
    in the report section (not visible is OK).

    Code the Format event of whatever report section the field control is
    placed in:

    [ControlToDisplay].Visible = Not [CheckBox]

    That field, only in records that do NOT have the check, will be shown.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page