joing labels and text boxes

[colkas]

Hi

I have a lable called label93 which as a caption Estimate Date:
I also have a txtbox called text93 with control source =Now()

When ti shows on the report

Estimate Date: 07/05/2011

How can I get them both so they are next to each other so it looks like

Estimate Date: 07/05/2011

I have tried to align them next to each other and move them on top of each other etc.... but I can find a way to achiceve this.

Any ideas

Thanks

 

[colkas]

Or How can I get back the textbox lable.

If you delete label for your txtbox is there a way to retrieve it.

Thanks

 

[Galaxiom]

You should be able to move the label into the right position then set the Alignment property of the label caption to Right.

To reassociate a label to a control that has no label, place a label and Access will ask you which control you want to associate with it. (Access 2007)

This can be easily done by selecting the label, cut and then paste.

Anothe way is to not use a label at all and give the textbox the following control source:

 ="Estimate Date: " & fieldname

However the textbox cannot have the same name as the fieldname as this will cause a circular reference. Just change the name of the textbox.

 

[colkas]

Hi

Thanks for the reply. I added the fields again and adjusted manually, but i like you method
="Estimate Date: " & fieldname and will keep this for future reference.

Many thanks