Re: How to create Flexible Access report

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

I thought I did suggest setting it to grow in my response.

Yes, all the controls below would move down.

Yes, you can set items to shrink if there is no data in them (or set them to
one pixel high and set them to GROW).

--
Hope that helps!

RBear3
..

"icccapital" <icccapital@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC28B478-B61F-446E-B9AD-4563C96500AF@xxxxxxxxxxxxxxxx
Both of those are very good suggestions RBear and Carl. If I were to
combine
these two responses and create a textbox like Rbear suggests and just make
it
very small, but can grow like Carl suggests, would that logically move all
the other controls downward to fit itself? Is it possible to do this with
expresssions as well? For example I have some fields that should only
show
up if certain characteristics are true, ie one number is greater than
another
or it is greater than 0. Something like that, so it is a tier where the
first would definitely show up on the page, but 2-5 might not depending on
the criteria. Could I put the expression in &(expr)& and have it
sometimes
show and expand? Thanks again.

"RBear3" wrote:

One way if to build your address in one textbox and include carriage
returns. You can set the text box's CAN GROW to true. It will then
expand
to fit the data. In the textbox, you'd have something like...

=[FirstName] & " " & [LastName] & chr(13) & chr(10) & [Address1] &
chr(13) &
chr(10) & ([Address2] + chr(13) + chr(10)) & [City] & ", " & [State] & "
" &
[ZIP]


The "+" combined with the Address2 line will cause the carriage return to
be
included only if there is something in Address2.

--
Hope that helps!

RBear3
..

"icccapital" <icccapital@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E12ED01-36BA-4284-B401-FD30C678E58C@xxxxxxxxxxxxxxxx
I have two areas on my report where it would be nice if it were
flexible.
One is if there is a second address or not. So if a customer does have
a
second address (ie suite, etc) I would want that to show up under the
first
address portion, but if they don't I would prefer not to have a big
space
so
that area should compress and compress the whole report. The other
portion
of the report is along the same lines, but would involve about 5 lines
that
would show up or not show up. I am capable with vba, but haven't done
much
in access. Any suggestions or direction you can give is helpful, thank
you.





.

Relevant Pages

  • Re: Returning variables from external form
    ... The big problem with global variables ... Response: Ah – did not know that. ... The question of changing the names of the controls need never ... The form and the report are not the only place I use an “external” form. ...
    (microsoft.public.access.formscoding)
  • OT:New Documents Suggest DoD Watchdog Covered Up Intelligence Units Work Tracking 9/11 Terrorists
    ... Asymmetrical Threats Division, who is identified in government documents ... Bin Laden as well as suspected al-Qaeda terrorists and members of the ... When the DoD prepared its report based on Iron Man's complaints, ... Truthout with documents he received in March 2010 in response to his FOIA ...
    (alt.sports.basketball.nba.la-lakers)
  • Re: "Support"
    ... world (see Service Pack 3 Installation Problems in the newsgroup). ... "helpful" response I got was to send a service report to Microsoft. ... symptoms to Microsoft one would wonder about whether it ...
    (microsoft.public.windowsupdate)
  • Re: select column name base on users choice
    ... definition at runtime so that its controls are bound to the selected columns. ... In fact you are going to have to amend the report definition anyway, ... But this will only store the query in a string, ...
    (microsoft.public.access.queries)
  • Re: Microsoft has utterly failed with Access 2007
    ... Access 2003 already included grouped controls. ... if I have a typical report with a line of details ... property sheet opening ... In other words again the keyboard choices and general design of access 2007 ...
    (microsoft.public.access.modulesdaovba)