RE: Text box not showing appopriate information
- From: "Clayton Osterman" <ClaytonOsterman@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Jun 2005 07:41:02 -0700
I believe I found the cause of my problem, but I am hoping if somebody can
verify this for me. I think that the problem is that I have the can grow
property set with a line spacing greater than 0. Putting a border around the
text box I could watch the size of the text box, and it was the same size as
I increased the line spacing. Hence, the text box control was growing to fit
the size of the data with 0 line space, but needed to be bigger due to the
increased line space and was then leaving out the last line of data.
"Clayton Osterman" wrote:
> I am designing a report for our customers to show upcoming changes to their
> product and their options with regard to the change. Not all customers will
> have the same number of options. I have a table with the customer
> information and options (which includes their rates and descriptions) which
> feeds into a report. I am trying to present some of this infomation in a
> text box with the Can Grow Option set to yes and with the Control Source
> property set to: =Trim([BCPOpt2Descr]) & IIf([BCPOpt3Rate]<>0,"
> " & Trim([BCPOpt3Descr]),"") & IIf([BCPOpt4Rate]<>0,"
> " & Trim([BCPOpt4Descr]),"") & IIf([BCPOpt5Rate]<>0,"
> " & Trim([BCPOpt5Descr]),"") & IIf([BCPOpt6Rate]<>0,"
> " & Trim([BCPOpt6Descr]),"") & IIf([BCPOpt7Rate]<>0,"
> " & Trim([BCPOpt7Descr]),"") & IIf([BCPOpt8Rate]<>0,"
> " & Trim([BCPOpt8Descr]),"")
> Carriage returns are the first value of the strings in the IIf statements
> when the statement is true to provide a single line for each option. There
> is always a second option, but there may not be options 3 - 8, with the lower
> numbered options being filled first. In the case of just two options (option
> 1 is shown elsewhere on the report) the text box is displayed correctly. If
> there are more than two options, the last option is not shown even though
> there is a non-zero rate. This happens no matter which option is the last.
> If I make the text box big enough to fill the max 7 lines, it will show the
> final line appropriately, but leaves unwanted white space after the last
> option in the cases where there are less than 8 options. Setting the text box
> Can Shrink property to yes will then remove the white space, but will remove
> the last option again. Can anyone help me get the text box to display the
> correct infomation? Thank you.
.
- References:
- Text box not showing appopriate information
- From: Clayton Osterman
- Text box not showing appopriate information
- Prev by Date: Re: two copies of same report on 1 page
- Next by Date: Re: two copies of same report on 1 page
- Previous by thread: Re: Text box not showing appopriate information
- Next by thread: Print Report to pdf for each record in recordset
- Index(es):
Relevant Pages
|
