Prev: Blank page in middle of report
Next: Report filter question
From: ramudo on 22 Mar 2010 14:24
I am a novice in Access. I have a report that has two lines for a
description. The report provides an additional line for the second line of
the description in the record. Sometimes, however I only need to use one
line, and not the second one. How can I get the report to not provide for
the second description line if this field is blank? Thank you for your help.
From: Jeff Boyce on 22 Mar 2010 14:26
Check Access HELP for the CanGrow and CanShrink properties for that second
control on your report.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"ramudo" <ramudo(a)discussions.microsoft.com> wrote in message
news:CA649E80-52A3-4A6D-A05E-C932EAE6541D(a)microsoft.com...
>I am a novice in Access. I have a report that has two lines for a
> description. The report provides an additional line for the second line
> of
> the description in the record. Sometimes, however I only need to use one
> line, and not the second one. How can I get the report to not provide for
> the second description line if this field is blank? Thank you for your
> help.


From: Duane Hookom on 22 Mar 2010 14:49
Set the text box Can Shrink property to "Yes" and it will dissappear. Any
controls totally below the text box will move up if there are no controls to
the left or right of the additional description text box.
--
Duane Hookom
Microsoft Access MVP


"ramudo" wrote:

> I am a novice in Access. I have a report that has two lines for a
> description. The report provides an additional line for the second line of
> the description in the record. Sometimes, however I only need to use one
> line, and not the second one. How can I get the report to not provide for
> the second description line if this field is blank? Thank you for your help.
From: ramudo on 22 Mar 2010 16:08
Thank you very much for your help.

"Duane Hookom" wrote:

> Set the text box Can Shrink property to "Yes" and it will dissappear. Any
> controls totally below the text box will move up if there are no controls to
> the left or right of the additional description text box.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "ramudo" wrote:
>
> > I am a novice in Access. I have a report that has two lines for a
> > description. The report provides an additional line for the second line of
> > the description in the record. Sometimes, however I only need to use one
> > line, and not the second one. How can I get the report to not provide for
> > the second description line if this field is blank? Thank you for your help.
From: ramudo on 22 Mar 2010 16:09
Thank you very much for your help.


"Jeff Boyce" wrote:

> Check Access HELP for the CanGrow and CanShrink properties for that second
> control on your report.
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "ramudo" <ramudo(a)discussions.microsoft.com> wrote in message
> news:CA649E80-52A3-4A6D-A05E-C932EAE6541D(a)microsoft.com...
> >I am a novice in Access. I have a report that has two lines for a
> > description. The report provides an additional line for the second line
> > of
> > the description in the record. Sometimes, however I only need to use one
> > line, and not the second one. How can I get the report to not provide for
> > the second description line if this field is blank? Thank you for your
> > help.
>
>
> .
>
 | 
Pages: 1
Prev: Blank page in middle of report
Next: Report filter question