Vertical centering in reports

[Guest]

I'm doing some tent cards in Access. I have the field set to display the
result of "=Trim([Name_First] & " " & [Name_Last])" and through the
properties window have set it to be centered horizontally.

How do I get it to center vertically as well? In FileMaker Pro text has
both a horizontal center and vertical center property.

Thanks for your help.

Also, if anyone knows of webpages designed for "so you're a FileMaker Pro
user now using access, here's the Access way to do what you did", please let
me know. (-:

 

[Stephen Lebans]

See:
http://www.lebans.com/verticaljustification.htm
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.

--

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

 

[Guest]

Ok, so I see in modules of the zipped database that there is a function
modTextHeightWidth, but I don't understand where one assigns that function to
the given text box. I don't see it on the textBox's properties or anything.

 

[Stephen Lebans]

Did you even bother to look at the code behind the sample Form and
Report?

--

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

 

[Guest]

I tried, but as I keep stating, I am new to Access. I was happy to just
notice that there was a module thingy. I'm not a programmer, nor do I know
Visual Basic.

So, I have to modify to code to assign it to a given text field?

Perhaps I should have been told that Access can't do such things unless one
is a programmer. If this is the way Access is, I'll make a case for us to
buy enough copies of FileMaker for our staff because the amount of time
required to program Access will end up costing more.

 

[Guest]

Actually, maybe this is too advanced for me. I'm not able to copy the module
from the database it arrived in (A2KVerticalJustifyVer1.mdb) to the one I
need it in to do my tent cards.

 

[Stephen Lebans]

Kit if you are willing to give up Access simply because it does not
natively support Vertical Justification for TextBox controls then there
is little sense of continuing this dialog.

Good luck with Filemaker.

--

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

 

[Guest]

Ok, thanks for the help. I'll see if someone else can show me how to
associate the code with other text boxes.

 

[Guest]

When I double-click on modTextHeightWidth in A2KVerticalJustifyVer1,
Microsoft Visual Basic opens up with a project called VerticalJustify which
contains 2 folders: Microsoft Office Access Class Objects containing
Form_customer and Report_customer, and Modules which contains
modTextheightWidth.

I tried exporting this module so I can import it into my database. I got the
module modTextHeightWidth into the new database, and when I double-click on
it, Microsoft Visual Basic opens up with a project containing the folder
Modules which contains modTextHeightWidh. I've not figured out how to get
the folder with Microsoft Office Access Class Objects in it.

I was able to export a class file, but don't seem to be able to import it.
(I'm told that the module name "Form_customer" is invalid.)