By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,692 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Sending One Field To The Printer

P: n/a
HB2
I have a form with several fields. I want to add a control to click on to
send the contents of one field to the printer.

Can someone offer help with the code for this?

Thank you
Bill
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bill, why not design a Report and put one control on it. Set it's control
source equal to the control on your form like so.

'If the control is on your main form:
=[Forms]![MyForm].Form.MyField
'If the control is on a subform:
=[Forms]![MyForm]![MySubForm].Form.MyField

'Place a command button on your form to print the report
Private Sub MyCommandButton_Click()
Dim stDocName As String
stDocName = "MyReport"
DoCmd.OpenReport stDocName, acNormal
End Sub
--
Reggie

----------
"HB2" <bg******@comcast.net> wrote in message
news:8e6yc.77989$Ly.46472@attbi_s01...
I have a form with several fields. I want to add a control to click on to
send the contents of one field to the printer.

Can someone offer help with the code for this?

Thank you
Bill

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.