Dynamic Report Format

  • Thread starter Thread starter Rao
  • Start date Start date
R

Rao

Hi,
Any suggestions on how to make MS Access Report Format a
Dynamic one. For Example a Purchase Order Format - Used by
one orgn. need not be same as the one used by other orgn.
So, if we want to offer a solution where both can change
format to suit to their own, how to achieve this in Access?

Thanks in Anticipation
Rao
 
Rao said:
Any suggestions on how to make MS Access Report Format a
Dynamic one. For Example a Purchase Order Format - Used by
one orgn. need not be same as the one used by other orgn.
So, if we want to offer a solution where both can change
format to suit to their own, how to achieve this in Access?
Click to expand...

You can set most control and report properties in the
report's Open event. If you want the users to make their
own settings, then use a form bound to a settings table
where they can specify what they want (use lots of
validation code to make sure they don't go nuts with it).

I you need more specific help, post back with more details
about the kind of things you want them to be able to change.
 
Hi Marsh,
Thanks for the reply. Could you please provide me some
more information or an example? My requirement is simple.
Let us say in my predefined format the Supplier code is on
the left most. However, the user wants it to be on the
Right most of the report. How to make him adjust the
report by himself?

Rao
 
Rao said:
Thanks for the reply. Could you please provide me some
more information or an example? My requirement is simple.
Let us say in my predefined format the Supplier code is on
the left most. However, the user wants it to be on the
Right most of the report. How to make him adjust the
report by himself?
Click to expand...

Sorry, but left and right are still way too vague. What you
will have to do is determine how the users are going to
specify whatever options you want to allow, put together a
form where they can specify it along with a table to
remember what they set the options to.

To display a value either on the left or right side of the
page, you may (depending on how you want the rest of the
line to look) have to adjust the Left property of each
control on the line. Just "moving" the one text box may be
as simple as:

If <theuseridentifier> = "Standard" Then
Me.txtSupplierCode.Left = 0
Else ' The other user
Me.txtSupplierCode.Left = 6 * 1440 ' 6 inches
End If

or, it could grow to an extensive sequence of code to set
all kinds of properties based on the report options table
mentioned above.
--
Marsh
MVP [MS Access]


 
Back
Top