Vary Appearance of Reports

[bigriff95969]

Greetings...

First time I was asked this so I thought it better to ask if any one already knows the best way to accomplish it:

I need the reports to vary in appearance so as to appear as letters prepared by different people.

Record 1 - fonts, line-height etc. are to vary from Record 2- and so on...

Slight differences in layout would be nice, such as paragraph width, margins, alignment of signature (image) etc. if its not out of the realm of possibility.

Has any one already done something like this?

Thanks

 

[PNGBill]

If you are serious about producing Letters, consider linking the data to a Word document.

Otherwise, you could have multply Reports.
Use an If Then statement to open the report matched to the writer.

 

[bigriff95969]

Re: Linking the data to word - Vary Appearance of Reports

I know I can output to word- but can that then vary the styling?

By "linking" do you mean something different that would allow various styling?

 

[PNGBill]

I am not experienced with using Word from Access but have tried it and it is not hard. As to how you would have the Letter format per the different access user, I do not know.
I do know Word is much better at producing a letter then access is.
Maybe there is some version of OpenArgs that will mean something to Word ??
Maybe you have Word Templates and use different templates for teh different users.

As far Access goes, my suggestion was to have a Report for each version you require - assuming it is only a few.
When the commend opens the report, it will select the version that matches the user.
This way you can use the full extent of access report tools but they are no match for word.

We settled with just using Access but our letters are simple and the same for all users.