Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.TransferText acExportHTML

Status
Not open for further replies.

swykpisz

Programmer
Joined
Jul 20, 2004
Messages
6
Location
US
When using this command above, is there a way to determine the font size of the final product? I'm exporting a query but need the font size of the information bigger like 24 font
 
Take a look at the 6th argument of the DoCmd.OutputTo method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
So I've gotten this far but not sure what the template would be, like the coding. I tried to make a template to enlarge the font. This is what I have;
DoCmd.OutputTo acOutputQuery, "Messages", acFormatHTML, "C:\MessagesForAssociates2.html", 0, "C:\template.html"

The html code for the template is:
<html>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Arial" size ="7" COLOR=#000000><CAPTION><B>Messages</B></CAPTION></FONT>
</TABLE>
</body>
</html>

What am I doing wrong?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top