VBA MS Access TextBox

Question

I am pretty new to VBA , trying to develop an application using MS Access forms. I have been struggling to display formatted text in a Text box.. Here is what am stuck with..

I have two text boxes , where i would like to grab the text from the two boxes and display in a third text box in two lines.[third text box i would like to use to hold multiple lines , so i have set the Scrollbar value to 'Vertical'). Below is the code

MsgBox Me.Text0.Value & vbNewLine & Me.Text2.Value   // This works , displaying in two lines
Me.Text4.Value = Me.Text0.Value & vbNewLine & Me.Text2.Value  //THIS DOES NOT WORK , ANY ISSUE WITH MS ACCESS TEXTBOX PROPERTY SETTING?

Please help me on this. Not sure what am doing wrong.. My apologies if this has been answered earlier in another thread , i tried many different attempts in my code but clueless.

Might try setting the "Enter Key Behavior" to "new line in field" — Tim Williams
– Tim Williams, Commented Nov 30, 2017 at 1:33
Hi , just figured it out.. I had the property set the "Rich text format" , I made that to "Plain Text" it worked. :-) — SAH
– SAH, Commented Nov 30, 2017 at 1:50

SAH · Accepted Answer · 2017-11-30 01:51:29Z

1

just figured it out.. I had the property set the "Rich text format" , I made that to "Plain Text" it worked. :-)

answered Nov 30, 2017 at 1:51

SAH

112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA MS Access TextBox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related