not print/show field for particular record

[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.

 

[Rick B]

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.

 

[fredg]

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.