variable width and position of text box

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

Guest

I am making an invoice with access 2002 reports. The first and last name fields are of different lengths. I would like them to appear with only one space between the two fields. When I set the "Can Grow" and "Can Shrink" properties to yes, the fields expand vertically instead of horizontally. Is there a way to set the controls so that they expand in width? Is there a way that the position is dependent on the width of the other?
 
You could create an unbound textbox.
In the control Source for the textbox put:

=[YourFirstNameField] & " " & [YourLastNameField]

the textbox would show: firstname lastname

or maybe
=[YourLastNameField] & ", " & [YourFirstNameField]

and the textbox would show: lastname, firstname

HTH

Hal



Lee Wigand said:
I am making an invoice with access 2002 reports. The first and last name
Click to expand...
fields are of different lengths. I would like them to appear with only one
space between the two fields. When I set the "Can Grow" and "Can Shrink"
properties to yes, the fields expand vertically instead of horizontally. Is
there a way to set the controls so that they expand in width? Is there a way
that the position is dependent on the width of the other?
 
Back
Top