Mailing Labels

  • Thread starter Thread starter Nigel M
  • Start date Start date
N

Nigel M

I thought I'd have a go at using Access to print some mailing labels,
rather than involving Word. The Label Wizard started off well, but then
I found that the field I wanted didn't appear in the list. I know the
field is in the query - this is the same one I've been using in Word.

The missing field is a "Memo", is this the problem? Is there a solution?

Also, in case I'm wasting my time, can the font sizes and colours of
individual fields be altered at a later stage?
 
You're correct. Memo fields don't show up when you use the label wizard.
You can though just add it to the design of the label once the wizard is
finished. And yes, you can change font sizes etc later on.
 
Memo fields don't show up when you use the label wizard.
You can though just add it to the design of the label...
Click to expand...

Thanks, sorted now. I thought I was going mad!
And yes, you can change font sizes etc later on.
Click to expand...

I found I had to add fields on separate lines, then move them, but I'm
nearly there. One thing I forgot (and I bet this is a problem) I need
for one of the fields (the memo) to be printed in CAPS.

Can this be done? If not, can the field be forced to all caps?
 
Change the control source of that control to =ucase(<whatever it said to
start with>)
 
Back
Top