Re: more help with skipping blank lines

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/27/04 

Date: Fri, 26 Mar 2004 20:46:38 -0600

The only method that I can think of that might work (other than a fair
amount of code) is to use a subreport for the column listing of benefits. 

-- 
Duane Hookom
MS Access MVP
"lynne" <anonymous@discussions.microsoft.com> wrote in message
news:1427c01c41372$ee6e9300$a401280a@phx.gbl...
> Lynne wrote:
>
> >I have a report that lists various employee benefits. If
> >a particular employee doesn't have a particular benefit,
> >my report originally printed the label for that benefit
> >with 0.00 in the amount field. Now they want me to
> >change it so that if the employee doesn't have a benefit
> >it just skips it altogether. I tried setting the fields
> >and their labels to invisible in the ON FORMAT property
> >if the amount is 0 but it leaves spaces. How can I get
> >it to print only those benefits that the employee has
> >without leaving big gaps in my columns?
>
> Marsh wrote:
> >To close up the space used by control that you've made
> >invisible, you need to set the control's (and its
> >section's)CanShrink property to Yes.
>
> I should have mentioned that next to my column listing
> benefits, I have a graph showing the relation of total
> benefits to total salary. When the graph is there, the
> CanShrink won't work. If I remove the graph, the spacing
> will shrink but the remaining items aren't evenly spaced
> ie if it skips 4 fields the space is larger than if it
> skips 1 or 2 fields. The result is a very uneven look. Is
> there some way to even out the spacing and keep my graph?
>
> Lynne
>
>
>

Relevant Pages

  • skipping blank lines - again
    ... If the amount is displayed in it's own ... >> I have a report that lists various employee benefits. ... When the graph is there, ...
    (microsoft.public.access.reports)
  • skipping blank lines - again
    ... > I have a report that lists various employee benefits. ... > with 0.00 in the amount field. ... When the graph is there, ...
    (microsoft.public.access.reports)
  • Re: Paul Thomas hears, but doesnt get it
    ... > the view of any particular employee - that is, ... > assuming that the matching contributions are intended to vest in at least ... > the power under a plan that is in fact qualified at the time of election, ... > the separate limitations on the maximum elective deferral amount). ...
    (misc.taxes)
  • Re: Re:The lawyers statement regarding my tax-on-nothing
    ... > In other words, if I can paraphrase, the VCR assumed that the amount by ... > amount contributed by the employee rather than by the employer (i.e., if, ... > income for the year of distribution). ...
    (misc.taxes)
  • How to get the most recent value from a table column?
    ... I want create a query that has the following fields on ... Employee: employee number that did this task ... Amount: amount of salary given for this employee for this particular ... But I cannot join weekno in both tables together since ...
    (microsoft.public.access.queries)