VbNewline or arrange text in a textbox as paragraph

[CORINEREYES]

Hi Everyone,

Good day!

I have this simple program that generates notes or sentences in a text box. My issue is i can not format the words or text in the textbox as like paragraph or sentence. I need to bring down some text in it at the top middle and bottom of the text box. Can someone please assist me?

Im currently using this code in a command button.

txtNotes = FGreetings & " " & vbNewLine & Reason & " " & EGreetings & " " & Sname

Thank you in advance,
Corine

[Micron]

No idea what you're asking for. I suggest you post what you have in your textbox as well as what you want it to be. Copy/paste from Excel sheet if you want a quick and easy table in your post.

[June7]

Can also copy/paste from Access table.

What does "in it at the top middle and bottom of the text box" mean? Perhaps a picture would be helpful.

[CORINEREYES]

Hi Micron,

This is a screenshot of my form in access, basically there are combo boxes , combo box contains values , you select the phrase you want then it will be displayed in the text box (note) that will generate a simple letter. As you can see, i need the body of the letter to be 2 lines after the first greeting and the end greeting 2 lines below the body of the letter and so on. I wanted a carriage return after those liines i mentioned.

[CJ_London]

Usual way would be to use vbcrlf

[Welshgasman]

Not sure what you are asking here?
You know the constant to get a new line.
You know the controls and what they contain, so you know where that constant should go?

What else are you asking?

[CORINEREYES]

Hi Micron,This is a screenshot of my form in access, basically there are combo boxes , combo box contains values , you select the phrase you want then it will be displayed in the text box (note) that will generate a simple letter. As you can see, i need the body of the letter to be 2 lines after the first greeting and the end greeting 2 lines below the body of the letter and so on. I wanted a carriage return after those liines i mentioned.

Hi All, sorry for the confusion, i just want to achieve this. Instead of the one i attached before. The event should happen when i press the transfer button.

[June7]

I use vbCrLf, never used vbNewLine. However, seem to produce same result.

Concatenate as many as needed to achieve desired spacing.

Don't even need VBA. Expression in textbox ControlSource could work.

Is this letter a report object?

[CORINEREYES]

Hi June7,

i use this code , but i does not work. Is there anything I'm missing?

txtNotes = FGreetings & " " & vbCrLf & Reason & " " & EGreetings & " " & Sname

[CORINEREYES]

i can try this, and re arrange all but is there something i needed to enable from the text box properties? I have seen a lot of codes like the one i have and it works. but mine does not.

[moke123]

If your trying to generate form letters, take a look at Albert Kallal's super easy word merge

http://www.kallal.ca/msaccess/msaccess.html

[Micron]

Re the none working expression: I don't think control is exposed to vba that way. On my phone so can't test. Could try
... & Chr(13) & Chr(10) &... instead.

[CJ_London]

Are you using richtext in your txtnotes control? If so you need to be using html code for things like carriage returns

[June7]

What does "not working" mean - error message, wrong result, nothing happens?

What is txtNotes - a field in table or just an unbound textbox?

If you want to provide db for analysis, follow instructions at bottom of my post.

[CORINEREYES]

Are you using richtext in your txtnotes control? If so you need to be using html code for things like carriage returns

this solves the issue! i used vbcrlf and vbnewline! it should be Plain text only.

Thanks a lot for all your suggestions and help! much appreciated