Dynamic Label

[tikrit]

Hello All,
Hope you're having a great day.
I know this might look a little bit strange but I really need it.
I have a label or several labels that are followed by combo box.
The combo box selects a name at once. The labels contains some texts just before this combo box and after it.
I want the size of the label and the combo box to change when I select a name so that the line will look consistant without any additional spaces between the combo box and labels.
I.E. I want the name to look just like the printed one in an ordinary MS word.
Thanks in advance,

 

[John Big Booty]

Welcome to the forum.

Can you let use know why you need to do this on a Form

 

[tikrit]

Dear John,
I am making a certificates so I need it to look like:
We certify that Mr. Mark Melon took the course and passed it.
Now,
(We certify that Mr.) & (took the course and passed it.) are labels.
(Mr. Mark Melon ) is selected from a combo box.
And you can notice that the name has a different lengthes. How can I make the labels resizable accordingly?
Thank you

 

[John Big Booty]

Given that you ultimate aim is to print this.

You should be looking at a report. Reports are designed to be printed whilst this is not really the role of a Form.

If you use a Report you can create a Query to collect all the data that needs to be printed on your certificate. You can then concatenate The leading text, the text from the Combo, and the trailing text together into one field.

 

[tikrit]

Thank you so much