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.