Title Position Adjustment

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

Guest

Hi there,

my report's title consist of lbl1 txtbox1 lbl2 , the length of txtbox1's
content is changable, so the margin between the txtbox1 and the other lable
is also changable. Could you tell me how to fix the margin.
 
clara said:
Hi there,

my report's title consist of lbl1 txtbox1 lbl2 , the length of
txtbox1's content is changable, so the margin between the txtbox1
and the other lable is also changable. Could you tell me how to fix
the margin.
Click to expand...

Get rid of both labels and change the ControlSource of the TextBox to...

="Label1Text " & FieldName & " Label2Text"
 
Hi Clara,

One way to achieve this is to concatenate your label information and data
field into a single text box with a control source like this:

="Label 1 text here " & [FIELDNAME] & " Label 2 text here"

Hope this helps.

Damian.

ps: Make sure FIELDNAME isn't also the Name of the textbox, or you may get
a circular reference problem.
 
Hi there,

my report's title consist of lbl1 txtbox1 lbl2 , the length of txtbox1's
content is changable, so the margin between the txtbox1 and the other lable
is also changable. Could you tell me how to fix the margin.
Click to expand...

Don't use the label textbox label combination.
Instead use one unbound text control.
="This is Label1 text " & [txtbox1] & " This is Label2 text."
 
Back
Top