Aligning Text

[Robert T]

When I align text in a label or a field, such as "Align Right", Access does
in fact place the text in ther far right side of the box. However, the text
is NOT centered vertically. In other words, text is lined up adjacent to the
top portion of the label or field, leaving most of the box below the text
blank. I don't like the look of text being placed in the upper right corner
of the box.

I want to line up the text either to the right or left horizontally, but I
also want to center the text within the box VERTICALLY. Can I do that in
Access 2000?

Thanks,
Robert

 

[Al Camp]

Try...
http://www.lebans.com/verticaljustification.htm
I haven't used it, but it sounds like what you want.
hth
Al Camp

 

[Bob Howard]

Ditto! I've used several things from the "lebans site" and they've all been
great! Bob.

 

[Robert T]

Hello Al:

I haven't download the file yet, but it does sound as if that's exactly what
I need. However, your answer implies there is no way to do such in Access
2000 which I think is a sloppy oversight. Do you know if this was corrected
in Access 2003?

Thanks for your help,
Robert

 

[Al Camp]

Robert,
Access 97, 2000, and 2003 do not have a built in vertical text alignment
capability.
Leban's code is for Access 2000 only.

You wrote...
... your answer implies there is no way to do such in Access 2000 which
I think is a sloppy oversight.

I hope that the term "sloppy oversight" refers to Microsoft's failure to
include a vertical centering function in 2000 and 2003, and not any "sloppy
oversight" in my response.

Al Camp

 

[Joan Wild]

Hello Al:

I haven't download the file yet, but it does sound as if that's exactly
what
I need. However, your answer implies there is no way to do such in Access
2000 which I think is a sloppy oversight. Do you know if this was
corrected
in Access 2003?

Thanks for your help,
Robert

Does Format, Size, To Fit give you something acceptable?

 

[Robert T]

Hello Al:

No, my comment wasn't directed at you personally, your answer was very
helpful and appreciated.

I was of course referring to MS, it's hard to believe text must be aligned
with the top border becasue there is no option to center text vertically. I
use another database product and that feature has been standard for years.

By the way, do you know why Leban's code doesn't work in Access 2003?

Have a great day,
Robert

 

[Stephen Lebans]

The code works fine in any version of Access after A97. The other poster
was mistaken in his comment that my code only works with A2K. The
correct statement would have been the code works with A2K or higher.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Al Camp]

I cut this from your website...

New April 07/2002

VerticalJustificationA2K.zip is a database containing a function to allow
for vertical centering of the contents of a Label or TextBox control. Works
with both Forms and Reports.

Access 2000 only!

Al Camp

 

[Robert T]

Hello Joan :

[Does Format, Size, To Fit give you something acceptable?]

I don't know, I never thought of using that option with field labels/data on
a form. I thought of that as an option for reports, ensuring all data fits on
the page. I'll try to find time to give it a shot later this morning and see
if it helps.

Once again, I still don't understand why centering data isn't a built in
option.

Thanks for the suggestion,
Robert

 

[Robert T]

Hello Joan Wild:

OK Joan, I give up. Where do I find the "Format, Size, To Fit option" for
text labels and data fields on a form?

Robert

 

[Joan Wild]

Hello Joan :

[Does Format, Size, To Fit give you something acceptable?]

I don't know, I never thought of using that option with field
labels/data on
a form. I thought of that as an option for reports, ensuring all
data fits on
the page.

There is no such option for reports (fit to page)

OK Joan, I give up. Where do I find the "Format, Size, To Fit
option" for text labels and data fields on a form?

In design view of the form, select one more controls. Go to the
Format menu, choose Size, and then To Fit. It will reduce the size
of the box to fit the text in a label (so in your case it will make
the text appear centered vertically). However, Stephen Lebans solution
will work for you in 2003.

As for why it's not available, I don't know. Why don't you post a
suggestion to that effect?

 

[Robert T]

Hi Joan:

The option was not on the Properties/Forma tab of the field which I checked
multiple times. However, I finally looked on the Main Menu and eventually
found the option you described. It does work as you suggested, however, it
obviously shrinks the size of the field, which isn't what I want. Therefore,
I think the Lebans solution sounds like a much better alternative.

Thanks for your help,
Robert

 

[John B]

you can also use the textbox top margin to roughly align center.

It is tedious but if you select multiple textboxes that is a few seconds job.

JB