Welcome to SPN

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

Sign Up Now!

Re: Printing a Report

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

  1. Jennifer

    Jennifer
    Expand Collapse
    Guest

    Steve,
    I think I've figured out where my problem lies. I've got two separate
    boxes, one that is the actual boxes that generates the information for the
    field and one that just names the field. The generated box can be shrunk,
    however, the box with just the name of the field cannot. Any tips? Thanks!




    "Steve Schapel" wrote:

    > Jennifer,
    >
    > Well, looks like I didn't understand after all. If you are trying to
    > reduce blank spaces on the report where there is no data in a field, the
    > Can Shrink would work, as lond as there are no other controls on the
    > report at the same horizontal level.
    >
    > So, can you please give some details, with examples, of exactly what you
    > want to happen, and what is happening now that is different from what
    > you want? Thanks.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Jennifer wrote:
    > > Steve,
    > > That didn't work.

    >
     
  2. Loading...

    Similar Threads Forum Date
    Controversial War over Private Printing of "Birs" Intensifies Hard Talk Jul 9, 2011
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014

  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Jennifer,

    It sounds like you have a textbox, which is bound to the field in the
    report's underlying query, so this is where the actual data appears.
    And then you have a label, on the same horizontal level on the report as
    the textbox. Is this correct?

    Ok, the Can Shrink property does not apply to a label.

    One way that you can handle this is to change the label to a textbox.
    This will be an unbound textbox. You can format it so it looks like the
    label. And then, using your example of the Address field, you can put
    something like this in this unbound textbox's Control Source property...
    =IIf(IsNull([Address]),Null,"Address")
    And then set this textbox's Can Shrink property also to Yes.
    What will happen here is that if there is an address in the Address
    field, the unbound textbox will display the word Address, and look like
    a label, but if there is no address, it will not show anything, and
    should Shrink along with the actual Address textbox. Hope that makes sense.

    --
    Steve Schapel, Microsoft Access MVP

    Jennifer wrote:
    > Steve,
    > I think I've figured out where my problem lies. I've got two separate
    > boxes, one that is the actual boxes that generates the information for the
    > field and one that just names the field. The generated box can be shrunk,
    > however, the box with just the name of the field cannot. Any tips? Thanks!
    >
    >
    >
    >
    > "Steve Schapel" wrote:
    >
    >> Jennifer,
    >>
    >> Well, looks like I didn't understand after all. If you are trying to
    >> reduce blank spaces on the report where there is no data in a field, the
    >> Can Shrink would work, as lond as there are no other controls on the
    >> report at the same horizontal level.
    >>
    >> So, can you please give some details, with examples, of exactly what you
    >> want to happen, and what is happening now that is different from what
    >> you want? Thanks.
    >>
    >> --
    >> Steve Schapel, Microsoft Access MVP
    >>
    >>
    >> Jennifer wrote:
    >>> Steve,
    >>> That didn't work.
     
  4. Jennifer

    Jennifer
    Expand Collapse
    Guest

    Steve,
    I'm getting a box that pops up titled "Enter Parameter Value". What's this?

    "Steve Schapel" wrote:

    > Jennifer,
    >
    > It sounds like you have a textbox, which is bound to the field in the
    > report's underlying query, so this is where the actual data appears.
    > And then you have a label, on the same horizontal level on the report as
    > the textbox. Is this correct?
    >
    > Ok, the Can Shrink property does not apply to a label.
    >
    > One way that you can handle this is to change the label to a textbox.
    > This will be an unbound textbox. You can format it so it looks like the
    > label. And then, using your example of the Address field, you can put
    > something like this in this unbound textbox's Control Source property...
    > =IIf(IsNull([Address]),Null,"Address")
    > And then set this textbox's Can Shrink property also to Yes.
    > What will happen here is that if there is an address in the Address
    > field, the unbound textbox will display the word Address, and look like
    > a label, but if there is no address, it will not show anything, and
    > should Shrink along with the actual Address textbox. Hope that makes sense.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    > Jennifer wrote:
    > > Steve,
    > > I think I've figured out where my problem lies. I've got two separate
    > > boxes, one that is the actual boxes that generates the information for the
    > > field and one that just names the field. The generated box can be shrunk,
    > > however, the box with just the name of the field cannot. Any tips? Thanks!
    > >
    > >
    > >
    > >
    > > "Steve Schapel" wrote:
    > >
    > >> Jennifer,
    > >>
    > >> Well, looks like I didn't understand after all. If you are trying to
    > >> reduce blank spaces on the report where there is no data in a field, the
    > >> Can Shrink would work, as lond as there are no other controls on the
    > >> report at the same horizontal level.
    > >>
    > >> So, can you please give some details, with examples, of exactly what you
    > >> want to happen, and what is happening now that is different from what
    > >> you want? Thanks.
    > >>
    > >> --
    > >> Steve Schapel, Microsoft Access MVP
    > >>
    > >>
    > >> Jennifer wrote:
    > >>> Steve,
    > >>> That didn't work.

    >
     
  5. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Jennifer,

    What is the parameter it is asking for? This would normally indicate
    that you have a field referenced somehow in the report, that does not
    exist. Spelling error, or changing a field name, are probably the two
    most common causes.

    --
    Steve Schapel, Microsoft Access MVP


    Jennifer wrote:
    > Steve,
    > I'm getting a box that pops up titled "Enter Parameter Value". What's this?
    >
     
  6. Jennifer

    Jennifer
    Expand Collapse
    Guest

    One last question. It works, but when it shrinks, it's not deleting the
    space in between, and there's 2 seperate text boxes in some (i.e. ofc ac &
    ofc # that go with the office label). WHen I change the label to a text box
    though, it doesn't keep the label name, it changes it to what I have in the
    if statement. ANy suggestions?

    "Steve Schapel" wrote:

    > Jennifer,
    >
    > What is the parameter it is asking for? This would normally indicate
    > that you have a field referenced somehow in the report, that does not
    > exist. Spelling error, or changing a field name, are probably the two
    > most common causes.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Jennifer wrote:
    > > Steve,
    > > I'm getting a box that pops up titled "Enter Parameter Value". What's this?
    > >

    >
     
  7. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Jennifer,

    Doo you mean something like this...
    =IIf(IsNull([ofc ac]+[ofc #]),Null,IIf(IsNull([ofc ac]),"ofc
    #",IIf(IsNull([ofc #]),"ofc ac","ofc ac #")))

    Otherwise, you will have to explain in a bit more detail exactly what
    you want to happen. Thanks.

    By the way, as an aside, it is not a good idea to use a # as part of the
    name of a field.

    --
    Steve Schapel, Microsoft Access MVP


    Jennifer wrote:
    > One last question. It works, but when it shrinks, it's not deleting the
    > space in between, and there's 2 seperate text boxes in some (i.e. ofc ac &
    > ofc # that go with the office label). WHen I change the label to a text box
    > though, it doesn't keep the label name, it changes it to what I have in the
    > if statement. ANy suggestions?
     
  8. Jennifer

    Jennifer
    Expand Collapse
    Guest

    Yes, but the label that I was trying to turn into a text box, it changes the
    wording to read what the "if" statement says...i.e for the ofc ac, it changes
    the label from office to ofc ac

    "Steve Schapel" wrote:

    > Jennifer,
    >
    > Doo you mean something like this...
    > =IIf(IsNull([ofc ac]+[ofc #]),Null,IIf(IsNull([ofc ac]),"ofc
    > #",IIf(IsNull([ofc #]),"ofc ac","ofc ac #")))
    >
    > Otherwise, you will have to explain in a bit more detail exactly what
    > you want to happen. Thanks.
    >
    > By the way, as an aside, it is not a good idea to use a # as part of the
    > name of a field.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Jennifer wrote:
    > > One last question. It works, but when it shrinks, it's not deleting the
    > > space in between, and there's 2 seperate text boxes in some (i.e. ofc ac &
    > > ofc # that go with the office label). WHen I change the label to a text box
    > > though, it doesn't keep the label name, it changes it to what I have in the
    > > if statement. ANy suggestions?

    >
     
  9. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Jennifer,

    Please tell me *exactly* what you have entered for the Control Source of
    the label you have changed into a textbox. Also, please tell me
    *exactly* what you want it to say. Also please tell me *exactly* what
    is the name of the field that this "label" refers to. Also please tell
    me *exactly* what conditions apply to the display of the "label". Thank
    you.

    --
    Steve Schapel, Microsoft Access MVP


    Jennifer wrote:
    > Yes, but the label that I was trying to turn into a text box, it changes the
    > wording to read what the "if" statement says...i.e for the ofc ac, it changes
    > the label from office to ofc ac
    >
    > "Steve Schapel" wrote:
    >
    >> Jennifer,
    >>
    >> Doo you mean something like this...
    >> =IIf(IsNull([ofc ac]+[ofc #]),Null,IIf(IsNull([ofc ac]),"ofc
    >> #",IIf(IsNull([ofc #]),"ofc ac","ofc ac #")))
    >>
    >> Otherwise, you will have to explain in a bit more detail exactly what
    >> you want to happen. Thanks.
    >>
    >> By the way, as an aside, it is not a good idea to use a # as part of the
    >> name of a field.
    >>
    >> --
    >> Steve Schapel, Microsoft Access MVP
    >>
    >>
    >> Jennifer wrote:
    >>> One last question. It works, but when it shrinks, it's not deleting the
    >>> space in between, and there's 2 seperate text boxes in some (i.e. ofc ac &
    >>> ofc # that go with the office label). WHen I change the label to a text box
    >>> though, it doesn't keep the label name, it changes it to what I have in the
    >>> if statement. ANy suggestions?
     
  10. Jennifer

    Jennifer
    Expand Collapse
    Guest

    Steve,
    Ok, I got everything to work, now I have a lot of white space. How can I
    get rid of the white space in places that need it?

    "Steve Schapel" wrote:

    > Jennifer,
    >
    > Please tell me *exactly* what you have entered for the Control Source of
    > the label you have changed into a textbox. Also, please tell me
    > *exactly* what you want it to say. Also please tell me *exactly* what
    > is the name of the field that this "label" refers to. Also please tell
    > me *exactly* what conditions apply to the display of the "label". Thank
    > you.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Jennifer wrote:
    > > Yes, but the label that I was trying to turn into a text box, it changes the
    > > wording to read what the "if" statement says...i.e for the ofc ac, it changes
    > > the label from office to ofc ac
    > >
    > > "Steve Schapel" wrote:
    > >
    > >> Jennifer,
    > >>
    > >> Doo you mean something like this...
    > >> =IIf(IsNull([ofc ac]+[ofc #]),Null,IIf(IsNull([ofc ac]),"ofc
    > >> #",IIf(IsNull([ofc #]),"ofc ac","ofc ac #")))
    > >>
    > >> Otherwise, you will have to explain in a bit more detail exactly what
    > >> you want to happen. Thanks.
    > >>
    > >> By the way, as an aside, it is not a good idea to use a # as part of the
    > >> name of a field.
    > >>
    > >> --
    > >> Steve Schapel, Microsoft Access MVP
    > >>
    > >>
    > >> Jennifer wrote:
    > >>> One last question. It works, but when it shrinks, it's not deleting the
    > >>> space in between, and there's 2 seperate text boxes in some (i.e. ofc ac &
    > >>> ofc # that go with the office label). WHen I change the label to a text box
    > >>> though, it doesn't keep the label name, it changes it to what I have in the
    > >>> if statement. ANy suggestions?

    >
     
  11. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Jennifer,

    Set the Can Shrink property to Yes for all textboxes which may be empty,
    and all of the unbound textboxes that you are using to replace the
    labels. You also need to set the Can Shrink property to Yes for the
    applicable Section (presumably the Detail section) of the report.

    --
    Steve Schapel, Microsoft Access MVP

    Jennifer wrote:
    > Steve,
    > Ok, I got everything to work, now I have a lot of white space. How can I
    > get rid of the white space in places that need it?
    >
     

Share This Page