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

How to print selected fields to create a custom label in Access?

P: 1
Hello,

I am trying to create a custom label, with only selected fields to be printed on that label in MS Access. Is there a way to pick and select only few fields of a form and create a label?

Thank you, for your time and consideration :)
Mar 22 '17 #1
Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,430
The only way I can think of, and it's messy,is to have a check box against any additional fields you want (you may already have standard fields that you always want) and add them to your label.

The RecordSource for the label would be the same as the RecordSource for your form (with any relevant fiters.

The label must have a single text box and it's The ControlSource is built up of the required fields with linefeeds as needed.

Phil
Mar 23 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.