MS Access 2010 Reports - How to make a second line in a textbox

Hi Experts,

I have a textbox

I have Control Source as: Date Transfer when I use View I see:
Date Transfer
I want to see:
Date
Transfer
I tried: ="Date " & "Transfer "
but still
Date Transfer
I tried to hit enter after Date
but still not right

Thanks for any help.
Amour22015Asked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

Is the Multiline = true

then try

="Date " & vbCrLf & "Transfer "

or Ctrl+Enter in the textbox

Regards
0
 
Jeffrey CoachmanMIS LiasonCommented:
Or you can delete the controlsource for the textbox and build the correctly formatted string in the Format event of the section.

For example, if your textbox is in the detail section, then use code like this:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.YourTextbox="Date" & vbcrlf & "Transfer"
End Sub

...you may also wish to set the "CanGrow" property of the textbox to: Yes...

JeffCoachman
0
 
Amour22015Author Commented:
Great thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.