Changing format on the fly

[jason_nevin]

I've got a label followed by a variable length text box followed by another label. How do I format my report so that the second label moves left or right dependant on the length of the text box?

i.e

My name is [text box] and I'm pleased to meet you.

How do I get pleased to meet you to move left or right dependant on the size of the name in the text box?

Cheers.

 

[KenHigg]

me!mytextBox = "Hello, My name is " & [mytextfld] & ", pleased to meet you!"

???
ken

 

[ray705]

What Ken is trying to say is don't use three fields when all you need is one.
Put the code in the OnFormat event and concatenate your static text with your variable field data into an unbound field - or even in the Caption of a label type field.

 

[Rich]

Kens code doesn't need any vba

 

[ray705]

Kens code doesn't need any vba

If that's not vba then what is it?

 

[Rich]

the left eye not following the right take out the Me.MyTextBox and it becomes the control source for a textbox

 

[jason_nevin]

Thanks guys. I thought that it would be a feature of Access somewhere but the methods you've given are effective.

FYI; I used the Control Source of a text box.

Cheers.