Columnar labels truncated

  • Thread starter Thread starter John
  • Start date Start date
J

John

Access 2003

I create a columnar form.
The labels are truncated.
I select the labels.
I use Format | Size | To Widest
The labels are still truncated.
Since this does not work, I wanted to move the
textboxes to the right, then resize the labels.
There is just one problem.
If I select the textboxes, the labels are also selected.
Hence, I cannot move the textboxes to the right
without moving the labels with them.
I cannot select the textboxes without implicitly
having the labels selected.
So how do I move the textboxes to the right so
I can make the labels wider?

Thank you for your feedback.
 
John,
When the label is selected, click and hold the upper left corner and drag the label
whever you want. (should show a hand with pointing finger)
Or, when the label is selected you can selected midway up the left side, or right side
(shows a <--> arrow) and widen or narrow the label.
See "Move a control or its label separately" in Help.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Al

Thank you for your help.
Your feedback about using
"Move a control or its label separately"
in Help was very useful.
When I previously looked in the Help,
I was looking for the wrong topics.

I had selected all the labels in a column which did not work.
When I selected a single label as you suggested,
I was able to move the label independently of the textbox.
One should be able to select all the labels and move them
independently of the textboxes. I suspect this is a bug.
Therefore, I will move only a single textbox at a time and
then widen it's label.
It's unfortunate that during the creation of the columnar form,
Access does not always correctly set the width and spacing for the
label and textbox.

Thanks again.
 
John,
You'll need to explain in detail what you mean by a columnar form, and...
I had selected all the labels in a column which did not work.
That doesn't seem to make sense...
If your referring to a continuous form, and you reposition the label on one control,
all records will show that same positioning. Also, when designing a continuous form, it's
usual to place just one label in the PageHeader for each column.
Show me an example (with just a few records and a few fields, what your form looks
like)

Also, if you don't want the labels "stuck" to the text control, select just the label,
then Cut & Paste it back onto the form. Now the label is no longer attached to the text
control, and can be handled as a stand alone object.
To reattach a label to a text control, select that same label again, and Cut it. Then
select the control associated with it, and Paste. The label will now be attached to that
text control again. ( I refer to "text control", but any object can have a label
attached or detached)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top