W
William Benson
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.
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.