Text box with two variable in 2 lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ve a textbox in a report name "Designation" and assign it controlSource
property as [FirstName] &" " & [Designation]
It display the result as
Abdul Basit Khan Officer

I want to display the result as

Abdul Basit Khan
Officer

Please note that the name and designation can be different, and i want to
centralized the designation with respect to name,

Please give me solution
 
Abdul said:
I ve a textbox in a report name "Designation" and assign it controlSource
property as [FirstName] &" " & [Designation]
It display the result as
Abdul Basit Khan Officer

I want to display the result as

Abdul Basit Khan
Officer

Please note that the name and designation can be different, and i want to
centralized the designation with respect to name,
Click to expand...


You can get the designation on a separate line by using:
= [FirstName] &Chr(13) & Chr(10) & [Designation]

but you will not be able to left adjust the name and center
adjust the designation using a single text box. You can
either center adjust the entire text box (i.e. both lines)
or use two separate text boxes.
 
Back
Top