coding to make field visible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a report which is generated from the main table however in the coding
we are trying to tell the report not to show a lable and box (with info from
table) if the field on the table is blank. Only fields which have data on the
table are to be shown.

Can someone please help with this.

We have decided not to use a query due to there can be over 50 different
veriasions therefore we thought this would be better and easier and not take
up as much room.

We would appreciate any help.

Thanks
 
Noemi

One possible approach would be to use the control's (box, with associated
label) CanGrow and CanShrink properties. If you set these both to Yes, and
if there are not any controls WITH data located directly to the right of
this control, setting these properties will allow Access to (grow or shrink)
the report, leaving out the space when there is no data.

I am curious, however, that you have "over 50" variations of your query --
is there a chance you are allowing multiple different selection criteria?
 
Hi Jeff
I am not sure whether that approach will work because a column can be blank
in the table but another column would replace the location of the label text
box. Can you please clarify for me what you mean by it will shrink the report?

The look of the report is not based on a query run by someone requesting
information but based on information provided in the main form.
The main form is used to populate the table however there are different
variationson the main form. When particular information is selected then
certain text boxes, check boxes ect are displayed for user to select from and
depending on the selections also depends on the information to be provided on
the Report as the report will be emailed to different people which will
contain the information everyone requires to do their work.

I hope this makes sense to you.
 
Noemi

Sorry, but I'm still a bit fuzzy on what you are trying to do.

The Access HELP listing on CanGrow and CanShrink will provide more
information, but the basic notion is that vertical space can be adjusted,
depending on whether a field has a value. I'm not familiar with a property
that modifies the horizontal spacing "on the fly".

Without an idea of the table structure, and/or an example of the actual data
and expected report layout, I'm just not visualizing what you are trying to
do... Perhaps one of the other 'group readers has a clearer picture?

Jeff Boyce
<Access MVP>
 
Back
Top