Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2005

Tip: Looking for answers? Try searching our database.

Table Appearance (Font related Properties)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
William Benson - 10 Sep 2005 03:13 GMT
I have a table which has some columns hidden and others not. I wanted the
appearance of a second table to look like this table because the two tables
sit one above the other as child objects on a form. I figured out how to
loop through fields and set the ColumnHidden property of relevant fields in
Table 2, matching Table 1. Now, at least the visible columns agree. I
cannot, however, figure out how to make the fontname and fontsize of the
Table 2 match that of Table 1.

I could probably have used CopyObject to create the second table's
structure, and this would all be moot. But, I didn't. Rather, I am creating
the second table using a Make Table query that harvests certain records from
Table1. I would like to conquer this using VBA if possible to access
FontName and FontSize properties from Table 1 and apply them to Table 2, but
the MSDN library gives no indication I can do so. I'm using Access 2003.
Thanks for any help.
William Benson - 10 Sep 2005 06:02 GMT
At the risk of training people not to bother to help me, I will mention that
I think I found the properties I was looking for, at this reference source:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/o
utput/F1/D2/S5A304.asp


       a.. DatasheetFontHeight
    a.. DatasheetFontItalic

       a.. DatasheetFontName
    a.. DatasheetFontUnderline

       a.. DatasheetFontWeight
    a.. Description

       a.. FrozenColumns
    a.. RowHeight

       a.. ShowGrid
    a..

>I have a table which has some columns hidden and others not. I wanted the
>appearance of a second table to look like this table because the two tables
[quoted text clipped - 11 lines]
> Table 2, but the MSDN library gives no indication I can do so. I'm using
> Access 2003. Thanks for any help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.