Letters Using Reports

[donifar]

Hello All-

I am creating a report that is a form letter. The letter states something like:

Hello, [Name]. you will be put in touch with [name2], whose number is [number]. more text continues.
​

Is there a way to do this without having to create separate text boxes or having a query that returns the text of the paragraph?

Thanks for any help!

 

[ScottGem]

Set your control source to:

="You will be put in touch with " & [name2] & ", whose number is " & [number] & ". more text continues."

 

[donifar]

i have paragraphs in there tho, and want to use just once text box. how do i denote hard returns?

Thanks!

 

[ScottGem]

I would use a separate text box for each paragraph, setting the Can Shrink/Grow properties to yes.

 

[donifar]

Thanks! I will give this a try.

One last q: is there a way to change the formatting of part of the text of a text box, or do i need sep. boxes?

Thanks so much.

 

[ScottGem]

Thanks! I will give this a try.

One last q: is there a way to change the formatting of part of the text of a text box, or do i need sep. boxes?

Thanks so much.

Not with a regular text box. You would have to get a Rich Text control from a third party vendor.

 

[donifar]

thanks for all your help!

 

[ScottGem]

glad to assist

 

[donifar]

one last question. i have a phone number as part of the text box, but the field itself isnt formated in the original table, so its showing up as just 10 numbers. is there a way to format it IN the text box, the same way you can trim() a field?

 

[ScottGem]

use the Format function:

& FORMAT([fieldname],"(###) ###-####")

or something like that

 

[donifar]

use the Format function:

& FORMAT([fieldname],"(###) ###-####")

or something like that

when i do that, it automatically changes it to "(#) #-#", and it comes out alllll wrong. are those singe double-quotes, or double single-quotes?

 

[donifar]

its also wierd, because when i just drop the field itself in, it seems to be formatted fine, just not when i use it in conjunction with text.

 

[ScottGem]

Double quotes. Check out the Format function to check the syntax.

 

[donifar]

i did. in fact i googled it and other website had the same solution, however it doesnt work for me.

 

[ScottGem]

Try Format(field,"000-000-0000"). That worked for me.