Create a paragraph using Field Values

[imran688]

Hi fellows,
How can I use different fields values to compose a paragraph?
I want to make a shipment notification letter using different fields. For Example,



Hi [ShipToName],
Your order of book [BookName] has been shipped via [Shipping_Service]. The tracking No. is [TrackingNumber].
Your order has been shipped to following address,
[ShipToName]
[Street1]
[Street2]
[City], [State] [ZIP],
[Country]

Then I also want to email it using outlook 2010 but that might be a different thread.

Regards,
Imran

[June7]

Use expression in textbox or VBA code that concatenates literal text with the variable field data, like:

="Your order of book " & [BookName] & " has been shipped via " & [Shipping_Service] & ". The tracking No. is " & [TrackingNumber] & "." & Chr(13) & Chr(10) & "Your order has been shipped to following address:" & Chr(13) & Chr(10) & [ShipToName] & Chr(13) & Chr(10) ... you finish it

If the expression is too long for textbox ControlSource, then use multiple textboxes.

If you build the string in VBA, expression length is not an issue. And can use vbCrLf in place of the Chr(13) & Chr(10) codes.

For email review
http://forums.aspfree.com/microsoft-...ro-447084.html
https://www.accessforums.net/program...ook-21903.html

[imran688]

That was really helpful but expression field is not accepting & Chr(13) & Chr(10) and reverts back to last saved expression when used these symbols.

[June7]

Very odd. I have no problem using them in a textbox ControlSource expression. Show your complete expression.

My example was missing an & in front of the [ShipToName] field.

[imran688]

Very odd. I have no problem using them in a textbox ControlSource expression. Show your complete expression.

My example was missing an & in front of the [ShipToName] field.

O ic. I thought you told me to put that expressions in a calculated field. Now i get it, i should use a text box on form and set its ControlSource expression like this. right?

[imran688]

Do you have any idea how can I email this paragraph to an email address in Email_Address field in same table?

[June7]

Did you review the links in post2 about email?

Start another thread if you have issues with attempt to code.

[imran688]

I am using the text to generate this test. The control source is set following code but chr(13) & Chr(10) does not seem to enforce a new line.
="Hello " & [ShipToName] & Chr(13) & Chr(10) & "Your order " & [ReferenceID] & " has been processed and shipped via " & [Shipping] & "."

[June7]

Don't know why that is not working in the textbox ControlSource.

Want to provide db for analysis? Follow instructions at bottom of my post.

[imran688]

Don't know why that is not working in the textbox ControlSource.

Want to provide db for analysis? Follow instructions at bottom of my post.

Is there any alternative so that I can achieve the desired results using vba. In the control source I can only access expression builder. How I can I set text box's value using vba?

[June7]

In code behind form that includes the textbox:

Me.textboxname = "Your order of book " & [BookName] & " has been shipped via " & [Shipping_Service] & ". The tracking No. is " & [TrackingNumber] & "." & vbCrLf & "Your order has been shipped to following address:" & vbCrLf & [ShipToName] & vbCrLf ...

The trick is figuring out what event to put the code in.

The expression in textbox should work unless it is too long. There is a limit to number of allowed characters in ControlSource property.

[imran688]

It started working as i selected the text format to plain text. Thanks for support.
Can you please give me a link to complete character code chart. I also wants to include "Tabs" in my text.

[June7]

Google: ASCII code chart

Try vbTab. I don't know what the Chr() equivalent would be. Can't find any reference that indicates there is one.

Review: http://www.ehow.com/how_8203280_chec...acter-vba.html