Re: For Duane Hookum

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Duane.

Ive got your suggestion to work now. Ive changed the code to the following
and set the textboxes font size to 16, then I made the box narrow,

=IIf([PrintDeep]="Yes"," ","")

Im still curious about the other suggestion though, which would seem to be
able to control the section height directly, without the need to add a
textbox. This is originally what I thought I could do. Ive asked for more
details but If I cant get it to work, Ill be happy to use your idea.

Thanks again for the help, JohnB


Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx> wrote in message
news:eL9SLBubFHA.1392@xxxxxxxxxxxxxxxxxxxxxxx
> Apparently values in the field [PrintDeep] have some effect on the text
box
> size. You could just set the font size to something around 16 points and
> fill the box with " " (spaces). I believe the spaces might be
> enough to make the box taller.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "JohnB" <JohnB@xxxxxxxxxxxxxxx> wrote in message
> news:OOeKaRsbFHA.3280@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi Duane
> >
> > I posted to you a while back, asking how users could contol the depth of
a
> > section in a report. Your response was as follows.
> >
> > You might want to set a control source to an expression like:
> > =IIf(Forms!frmYourForm!chkBox=True,String(20,Chr(13) & Chr(10)),"")
> > This should make the text box 20 "lines" tall.
> >
> > I was unable to get this running in work and due to limited time there
Ive
> > been playing around with this at home on a sample Access 97 db. My work
db
> > is Access 2002.
> >
> > Here Ive done things slightly differently. I have put a field called
> > PrintDeep in a table and made sure this is in the control source for the
> > report, although its not actually shown as a field on the report. This
> > field
> > is updated by users entering either Yes or No from a combo called
> > cboPrintDeep on a form. Ive set the text box in which I put the code to
> > CanGrow.
> >
> > Ive changed your code to the following
> >
> > =IIf([PrintDeep]="Yes",String(20,Chr(13) & Chr(10)),"")
> >
> > What this actually produces is two rows of tiny boxes. If I swop the Chr
> > values I get 10 rows of boxes, two on each row. So its deepening the
> > section
> > OK but I dont want to see anything in this text box.
> >
> > Can you see whats wrong with this?
> >
> > Thanks, JohnB
> >
> >
> >
>
>


.

Relevant Pages

  • Re: For Duane Hookum
    ... > Ive got your suggestion to work now. ... > Duane Hookom wrote in message ... >> MS Access MVP ... >>> report, although its not actually shown as a field on the report. ...
    (microsoft.public.access.reports)
  • Re: Sorting/Grouping
    ... Open your report in design view and then view the ... Sorting and Grouping dialog and enter the expression I suggested. ... > Many thanks for your suggestion. ... >>Duane Hookom ...
    (microsoft.public.access.reports)
  • RE: Sequential number in a query
    ... My suggestion was based on your comment "Report would look something like:" ... If you want this outside of a report, you must identify a unique field that ... Duane Hookom wrote: ...
    (microsoft.public.access.queries)
  • Re: dividing a fields value by 60
    ... definitely has a 0 in there, i had also tried your suggestion and embedded it ... "Duane Hookom" wrote: ... >> i have a report that is populated via a table and it works fine. ... >> due to a change in the underlying data i now need to divide the values by ...
    (microsoft.public.access.reports)
  • Re: For Duane Hookum
    ... >> Duane Hookom ... >> MS Access MVP ... >>> Ive got your suggestion to work now. ... >>> and set the textboxes font size to 16, then I made the box narrow, ...
    (microsoft.public.access.reports)