Creating Report using Text boxes & db fields

[Nancy J.]

I am creating a form letter using Reports and a query that pulls the data from several tables. Since the letter is mostly words in the letter I am using Text boxes and would like to add the table fields in where they need to be. This is a generic letter that can be used by all of my clients for their collection letter needs. Since their business names vary in size (number of letters) I would prefer that the report adjusts for it. I originally just did the text boxes with the verbage and then added the field next to the text box and added another text box after it. I don't want to create or modify the report (collection letter) for each client.

Is there a way to use text boxes with table or query fields mixed in?
Thank you

Nancy J.

[RuralGuy]

How about using a Super Easy Word Merge and a letter in Word?

[Nancy J.]

I would do that however, not all of our agents have MS Word - some just purchase the MS Access to track their data. Therefore, this isn't an option, but thank you.

Nancy J.

[RuralGuy]

TextBoxes are controls designed to displai fields in tables. They can also contain a formula that could display more than one field. I'm not sure I completely understand your question but I believe the answer is yes.

[Nancy J.]

That being the case then - the questions is how do I do it?

Text box (typed information) table field (continuation of the text box verbage).


Sample: Text box verbage (tbl field) text box verbage.

As a condition of (tbl field results - ABC Company) you agreed to pay.

Hope this gives you a better idea of what I am talking about.

Thank you again.

Nancy J.

[RuralGuy]

The control source of your TextBox will have a formula instead of being bound directly to a field:
=[TextVerbage] & [TableFieldName] & [OtherTextVerbage]

[Nancy J.]

I used the text box and typed in the following:

=[A reveiw of oor records indicates a past due balance of ] & [Balance] & [on your account. This]

It accepted it, however, when I run it I get the following error where the text box is located.

#Name?

Please advise.

Thank you

Nancy J.

[RuralGuy]

I thought the TextVerbage was coming from a field in a table (which I would recommend). Try:
="A reveiw of our records indicates a past due balance of " & [Balance] & " on your account. This"

[Nancy J.]

This is more of a form letter using a query and putting it to a report so multiple letters can be processed for the clients that are past due on their account. Hence the text boxes.

I tried what you suggested, however, I still got the same error #Name?

Any other suggestions?

Thank you
Nancy J.

[RuralGuy]

You will probably need to have a separate control bound to the [Balance] field on the report (because they can be a little touchy). Set its .Visible priperty to NO and put it behing the other Text controls to keep the design view clean and readable. Name the [Balance] control txtBalance and then reference the control instead of the field, although I think you can now reference the field since it is being pulled for the other control.

[Nancy J.]

tried what you said but still got the #Name? error. So now I am adding the text in the Query that was created and then adding the field into it as necessary. So far this seems to be working.

Sample:
BalanceStatement: "A review of our records indicates a past due balance of $" & Format([Balance],"Standard") & " on your account. This amount is now payable in full."

Seems like a lot more work, but it does look good.

Really appreciate your efforts and suggestions on this problem.

Nancy J.

[RuralGuy]

That's great. At least you got something working. If the Text were in a field in a table you would not need to call the programmer if you ever wanted to change the text. Just a thought.

[Nancy J.]

Definitely appreciate your fast responses to the problem I had. It was greatly appreciated.

Nancy J.

[RuralGuy]

Just glad you got it sorted Nancy.