Running reports as Letters 2

[paul123456]

Plz tell me if this is possible and how i would learn to do this. i am trying to have a report that shows like a letter. so when i hit a button on the main form it will put the users info in the letter in the approriate place. for exp, a letter like this

Date


first_name last_name
address1 address2
city, state zip


dear, first_name

body of letter


thank u,

Us

i want the info to export to the report so that i can have set templates and the user that is using the form can hit a button so that it will print this information out as a letter. is there a way to do this in access? Thanks, PAUL

 

[KenReay]

Hi

Yes, it is just a repoprt laid out to look like a letter, I do not understand your problem? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[paul123456]

well the problem i was thinking i might run into is when for example i have a sentence and it says something like
we are trying to contact "first_name" "last_name" plz call us soon.
well im thinking that when you put those two fields in there they are gonna have a big space between them. or is there a way to seperate them both with a single space? for example the "city", "state". won't it madder how big the city cell is then the state? or is there a way to seperate were they go by a comma? Thanks, PAUL

 

[KenReay]

Hi

One way around this problem is to define the address control as a single text box, with can grow set to yes, and its control source set to =City & " " & State

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[paul123456]

YOU DA MAN! thnx Thanks, PAUL

 

[paul123456]

One more thing, if u had to put it in the middle of the sentence is there a way to put a text box with the words that u want and in the middle a name. like for example

We have been trying to locate =[First] & " " & [Last] plz give a call.

is there a way to do this so that it looks like it is part of the sentence and not a big blank space? Thanks, PAUL

 

[KenReay]

Hi

same method, have a text box with cangrow set true, make the controlsource:

="We have been trying to locate" & Trim([First]) & " " & Trim([Last]) & " plz give a call."

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[paul123456]

Thnx Kim really helped out a lot, one more question. say u have a sentence like this.

="your social security number ends with xxx-xx-" & [soc]


how can i get just the last 4 numbers to be displayed?

Hey just wanted to thank u guys for helping us newbies learn. Thanks, PAUL

 

[VogonPoet]

You may want to consider using using Word's "Merge Mail" functionality for the letter(s). Just set the data source to the appropriate table/query in you Access DB and your set. You could also control the merge mail from your Access code.

The good thing about doing it this way is it allows you to use Words formatting features.

Michael

 

[KenReay]

Hi

="your social security number ends with xxx-xx-" & Right([soc],4)

VogonPoet's comments re Word are sound, you can get improved formatting that way, but it reuires more complex code than a simple Access report, is your VBA up to that?


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK