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 strongm 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
Jul 20, 2004
6
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