Re: user-adjustable reports

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

From: Paul Pedersen (no-reply_at_swen.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 13:40:24 -0800

Thanks for the suggestion. That should work well enough for vertical, but
I'd have to use a monospaced font to get the horizontal adjustment to line
up properly.

Also, it would require users to modify the reports themselves, which I'd
prefer to avoid.

"Allan" <Allan@discussions.microsoft.com> wrote in message
news:2702FEFA-7180-4683-9079-168482845119@microsoft.com...
> Hi Paul,
>
> I had a similar problem before and what I did is to use a 'slack' textbox
> at
> the beginning of the detail band using a font size of 6. The controls
> containing the actual data at set to move relative to the top of the
> detail
> band. I use a 'page-setup' form to allow the user to adjust the top and
> fill
> the 'slack' textbox with empty spaces during printing. You can also do
> this
> on the margin at the left by placing 'slack' spaces before the controls
> actual data like: SPACE(lnLeftMargin) + lcActualData + lcOtherActualData.
>
> Hope this will help,
>
> Allan
> "Paul Pedersen" wrote:
>
>> I have reports with one record in a tall detail band, no header, footer,
>> title, nor summary. These are intended to be printed on pre-printed
>> forms,
>> with the text boxes filling in the blanks.
>>
>> As expected, there are alignment differences for different users using
>> different printers. Alignment between the individual controls does not
>> change, but margins do.
>>
>> I can allow the user to edit the report, but these users are not
>> particularly computer savvy. I have grouped all the controls on the
>> report,
>> and I would like to allow the user to specify something like "move
>> everything up 1/8 inch and right 1/4 inch", then have the app make the
>> adjustment.
>>
>> Can this be done with report listeners? Or is it best to hack the report?
>> Something like
>>
>> REPLACE hpos WITH hpos + 10 FOR objtype = 8
>>
>> Or, since I have grouped the controls, is there a simple way to
>> reposition
>> the group? How are groups represented in the frx?
>>
>>
>>
>>

Relevant Pages

  • 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)
  • Re: multiple subform images per main search form record
    ... Thanks for pointing me to the links to the tutorial and to the report code. ... I have added the textbox controls ImageID1 through ImageID5 on the main ... In the subform itself, you can process a double-click event on each ... enlarged image and filter it analgous to how you filter the popup form ...
    (microsoft.public.access.formscoding)
  • Re: Bug in Access 2002 Reports
    ... from within the Detail Section format event ... This will give the report a feeling of being "to scale", when you look at it you can see there are smaller, larger or equal intervals. ... Access will format the section but it will remember the last placement of the controls. ...
    (microsoft.public.access.reports)
  • Re: Dynamically change subreport?
    ... Then I click a command button on this main form, and that fires off a report, which is based on a query which refers back to the customer combo box on the form. ... That report has two subreports, whose record sources are queries which also refer back to controls on the original form, including the customer. ...
    (microsoft.public.access.gettingstarted)