Welcome to SPN

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

Sign Up Now!

Fixed size in report

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

Tags:
  1. aleon

    aleon
    Expand Collapse
    Guest

    How do I fix variable data to not force the static data down or up, in a
    report? I've tried using OLE bound object, and inserted the subreport name
    (that contains the variable data) into the Control Source Property, but
    nothing displays. I'm trying to set address fields into a spot that fits
    into a window envelope, but the variable data shifts the address down.
    Thanks for your help.
     
  2. Loading...


  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Porobaly could use a bit more info on that sub field... but...
    If you don't care that some of the subreport data is not visible, control the size of
    that field. If a text field can be say 10 - 255 characters in the subreport, and anything
    over 125 characters causes your main form address to shift down... then use a calculated
    field like...
    = Left([YourTextFieldThatSometimesGrows], 125)
    in the subreport. Then, it will never force the subreport contol to grow.

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "aleon" <aleon@discussions.microsoft.com> wrote in message
    news:081E6091-DA73-4A8B-8F5E-953CDA7366EB@microsoft.com...
    > How do I fix variable data to not force the static data down or up, in a
    > report? I've tried using OLE bound object, and inserted the subreport name
    > (that contains the variable data) into the Control Source Property, but
    > nothing displays. I'm trying to set address fields into a spot that fits
    > into a window envelope, but the variable data shifts the address down.
    > Thanks for your help.
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Or set the cangrow property to no...

    HTH

    Pieter

    "Al Camp" <anon@anon.net> wrote in message
    news:e485rfimGHA.1252@TK2MSFTNGP02.phx.gbl...
    > Porobaly could use a bit more info on that sub field... but...
    > If you don't care that some of the subreport data is not visible,
    > control the size of that field. If a text field can be say 10 - 255
    > characters in the subreport, and anything over 125 characters causes your
    > main form address to shift down... then use a calculated field like...
    > = Left([YourTextFieldThatSometimesGrows], 125)
    > in the subreport. Then, it will never force the subreport contol to grow.
    >
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "aleon" <aleon@discussions.microsoft.com> wrote in message
    > news:081E6091-DA73-4A8B-8F5E-953CDA7366EB@microsoft.com...
    >> How do I fix variable data to not force the static data down or up, in a
    >> report? I've tried using OLE bound object, and inserted the subreport
    >> name
    >> (that contains the variable data) into the Control Source Property, but
    >> nothing displays. I'm trying to set address fields into a spot that fits
    >> into a window envelope, but the variable data shifts the address down.
    >> Thanks for your help.

    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Or set the cangrow property to no...

    HTH

    Pieter

    "Al Camp" <anon@anon.net> wrote in message
    news:e485rfimGHA.1252@TK2MSFTNGP02.phx.gbl...
    > Porobaly could use a bit more info on that sub field... but...
    > If you don't care that some of the subreport data is not visible,
    > control the size of that field. If a text field can be say 10 - 255
    > characters in the subreport, and anything over 125 characters causes your
    > main form address to shift down... then use a calculated field like...
    > = Left([YourTextFieldThatSometimesGrows], 125)
    > in the subreport. Then, it will never force the subreport contol to grow.
    >
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "aleon" <aleon@discussions.microsoft.com> wrote in message
    > news:081E6091-DA73-4A8B-8F5E-953CDA7366EB@microsoft.com...
    >> How do I fix variable data to not force the static data down or up, in a
    >> report? I've tried using OLE bound object, and inserted the subreport
    >> name
    >> (that contains the variable data) into the Control Source Property, but
    >> nothing displays. I'm trying to set address fields into a spot that fits
    >> into a window envelope, but the variable data shifts the address down.
    >> Thanks for your help.

    >
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4079 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  6. aleon

    aleon
    Expand Collapse
    Guest

    I had already tried setting the cangrow property to "no" and it doesn't work
    in this case. I'll try the other suggestion from Al and see how it goes.
    Thanks for your help.


    "Pieter Wijnen" wrote:

    > Or set the cangrow property to no...
    >
    > HTH
    >
    > Pieter
    >
    > "Al Camp" <anon@anon.net> wrote in message
    > news:e485rfimGHA.1252@TK2MSFTNGP02.phx.gbl...
    > > Porobaly could use a bit more info on that sub field... but...
    > > If you don't care that some of the subreport data is not visible,
    > > control the size of that field. If a text field can be say 10 - 255
    > > characters in the subreport, and anything over 125 characters causes your
    > > main form address to shift down... then use a calculated field like...
    > > = Left([YourTextFieldThatSometimesGrows], 125)
    > > in the subreport. Then, it will never force the subreport contol to grow.
    > >
    > > --
    > > hth
    > > Al Camp
    > > Candia Computer Consulting - Candia NH
    > > http://home.comcast.net/~cccsolutions
    > >
    > > "aleon" <aleon@discussions.microsoft.com> wrote in message
    > > news:081E6091-DA73-4A8B-8F5E-953CDA7366EB@microsoft.com...
    > >> How do I fix variable data to not force the static data down or up, in a
    > >> report? I've tried using OLE bound object, and inserted the subreport
    > >> name
    > >> (that contains the variable data) into the Control Source Property, but
    > >> nothing displays. I'm trying to set address fields into a spot that fits
    > >> into a window envelope, but the variable data shifts the address down.
    > >> Thanks for your help.

    > >
    > >

    >
    >
    >
     

Share This Page