Fixed size in report

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12196-fixed-size-in-report.html
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
Thanks for your help.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
> into a window envelope, but the variable data shifts the address down.
> Thanks for your help.

Or set the cangrow property to no...

HTH

Pieter

"Al Camp" 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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
>> nothing displays. I'm trying to set address fields into a spot that fits
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
>> into a window envelope, but the variable data shifts the address down.
>> Thanks for your help.
>
>

Or set the cangrow property to no...

HTH

Pieter

"Al Camp" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
> 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" 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

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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
> > 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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12196
> >> into a window envelope, but the variable data shifts the address down.
> >> Thanks for your help.
> >
> >
>
>
>